June 11, 2009 at 10:32 am
I have database name XYZ on SQL Serv 2000 and I did side by side migration on SQL Server 2008/2005
with that I did backup and restore process.
Migration was successful, but there some problems encountered after few weeks.
We have decided to move back to SQL 2000 environment.
We tried backuping the XYZ database (compatibility mode is still set to 2000, no changes was made)
on SQL Server 2008 environment. But we are trying to restore the database from 2000 gives us error.
Is there a way to rollback the database.
Please advise.
ACap:hehe:
June 11, 2009 at 10:59 am
acapucion (6/11/2009)
IWe tried backuping the XYZ database (compatibility mode is still set to 2000, no changes was made)on SQL Server 2008 environment. But we are trying to restore the database from 2000 gives us error.
Compatibility mode just affects how certain T-SQL statements are interpreted and executed. It does not affect the structure of the database. A database attached to a SQL 2008 instance is a SQL 2008 database and lower versions cannot understand the 2008 file structure/system tables. ie upgrade is done when the DB is attached/restored and is a one way process
Is there a way to rollback the database.
Script all the objects to file. Bcp all of the tables out to file. Create a new database on SQL 2000, recreate the objects and load all the data in.
If you have backups from before the upgrade it may be quicker to restore the latest of those and migrate over any changes afterwards.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply