January 18, 2009 at 3:49 am
Due to some problem i restored my database to Microoft Sql2008 Edition.
I tried to restore Backup of same to Microsoft SQL 2005 Server again it did not
work. Its ggiving downgrade compatibility error.
Can anybody suggest how to do that ??
I have read about procedure to First export Script in 2005 Format & then export
the data & respectively import to 2005. I would further like to know considering
database size of about 2 GB which format the data is recommended to export
so that it get imported to 2005 easyli.
Regards,
AShish U
January 18, 2009 at 9:09 am
I stumbled on this one last week: http://www.devx.com/dbzone/Article/40531
Once you restore to a 2008 instance, no matter where the backup is from, the structure changes. Therefore you cannot back it up and restore it to 2005, even if compatibility is 90.
January 18, 2009 at 9:23 am
ashish_1279 (1/18/2009)
I tried to restore Backup of same to Microsoft SQL 2005 Server again it did notwork. Its ggiving downgrade compatibility error.
Can anybody suggest how to do that ??
Short answer, you can't. Databases cannot be downgraded, once attached to a higher version the internal structure is changed, the database's internal version is changed and neither backup/restore nor detach/attach will get it working on a lower version.
The export-import procedure that you ran across is the only way to get the DB back to 2005.
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
January 18, 2009 at 9:44 pm
Thanks for the reply.
Can you suggest the procedure & opton to use while doing the import export option.
Regards,
Ashish Upadhyay
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply