Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backup & restore

Author  Topic 

sqlserverdbam
Yak Posting Veteran

54 Posts

Posted - 2009-01-06 : 13:31:51
Hi,

Can I restore DB on SQLSERVER 2000 from backup of SQLSERVER2005?

Does restore support backward compatability?

Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-06 : 13:33:13
No you can't.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-06 : 13:45:10
You will need to manually get the objects and data to 2000 using SSIS, DTS, bcp, scripts, or some other method. You could generate the schema and all of its dependent objects in 2005 using the scripting wizard. And then move the data using the methods already mentioned.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -