Monday, March 26, 2012

Restore to a previous version

Is it possible at all to restore back up from SQL 2005 onto SQL 2000?

If not, what is the bast way to transfer database stucture and data from SQL 2005 onto SQL 2000. Two machines are not on the same network...

No, it is not possible to restore a SQL 2005 server on SQL 2000.

You can script the database to a file and then apply to SQL 2000. Since your servers are not on the same network, the best option would be to export/import using bcp or BULK INSERT. Books on-line would have more information.

Peter

No comments:

Post a Comment