Groups | Blog | Home
all groups > sql server clients > march 2007 >

sql server clients : SQL Server 2005 backup



Rogers
3/27/2007 10:03:43 AM
Just wondering, If I take the SQL Server 2005 backup and can it be
restoreable in SQL Server 2000?

Scott Morris
3/27/2007 11:04:22 AM
[quoted text, click to view]

no

Hari Prasad
3/27/2007 8:34:41 PM
Hello,

Due to architectural differences you can not RESTORE a SQL 2005 datbase into
SQL 2000 server. What you can do is create the database manually and use DTS
to transfer objects and data from SQL 2005 database to SQL 2000.


Thanks
Hari


[quoted text, click to view]

AddThis Social Bookmark Button