calygirl
SSC Veteran
Points: 289
More actions
April 23, 2008 at 3:33 pm
#121488
Are there are known issues with restoring a SQL 2005 backup to SQL 2000?
happycat59
One Orange Chip
Points: 29389
April 23, 2008 at 9:24 pm
#806359
There is only one issue with restoring a SQL 2005 database into SQL 2000...it cannot be done. The physical structures between the 2 versions have changes and are not compatible.
ianT
SSCrazy
Points: 2956
April 25, 2008 at 4:32 am
#807045
you could use a tool (eg ssis) to move the data and objects from the 2K5 database to the sql2k database..
Not sure what problems you'd hit - I've only gone forward.
May be tricky if the 2K5 database is using features only available in sql2K5.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply