February 23, 2010 at 4:25 pm
Hi
I am having a db on sql server 2005 with compatibility level 80.Is it possible to restore the db on sql server 2000 using backup.(*.bak)
Kindly advice.
Binu
February 23, 2010 at 4:29 pm
nope, you cannot restore downlevel.
Script out the schema, run on 2000. Use SSIS or the export wizard to move the data.
February 23, 2010 at 4:35 pm
We cant rstore the db from bak even the compatibility is 80 ??
February 23, 2010 at 4:47 pm
The compatibility level has nothing to do with the structure of the file, or the way the backup is taken. It only determines how the 2005 engine interprets the code.
Once you upgrade to 2005, the structure of the file, and all backups changes. It's not a 2000 database anymore. It's a 2005 database that is read differently. You cannot restore this back on 2000.
February 23, 2010 at 11:01 pm
Steve is right, Check this out for steps.
EnjoY!
February 23, 2010 at 11:41 pm
Just a thought. Did you backup the database prior to upgrading it or restoring or attaching it to the sql 2005 instance? If you have that backup and there is room for data loss since that was made - then use it to go back to the sql 2000 box.
That is only if that backup was prior to the database being on 2005.
Otherwise, you will need to do as Steve suggested.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply