how can we get the restore in sql server 2000 of sql server 2005 data
+1
A:
You can't restore data from sql 2005 to 2000 only if you generate scripts with sql server 2000 compatibility. If you want create and restore backup can't do.
pho3nix
2009-06-29 09:29:49
A:
I do not think this is possible. You can't go from 2005 to 2000, what you would have to do is install SQL 2005 Express then restore to that and you should be able to manage the backup from there.
If you only need the database structure you can generate scripts for the entire database.
Burt
2009-06-29 09:30:04
A:
Colin
2009-06-29 09:30:58
I am under the impression that this is not going to work. The compatibility mode is for how the server behaves in response to commands and script, not for the internal structure of files.
Emtucifor
2009-07-02 05:44:12
A:
Use RedGate SQL Compare and RedGate SQL Data Compare to push the tables and data from SQL 2005 to SQL 2000.
You may be able to script the whole database from SQL 2000 compatibility mode, but getting the data requires something besides a backup and a restore. You could try bulk saving and bulk loading data, too...
Emtucifor
2009-07-02 05:45:59
+1
A:
I recently found myself in a similar position on a client site. I came across an article on the MSDN SQL Server Forum (second response from top) with a detailed walk-through on this issue.
I ran into a few issues with scripting users & had to hack my way through it a little bit, but it was a great starting point for me.
JR MacDonald
2009-07-16 05:15:12