December 15, 2010 at 3:21 pm
Is it possible to take a backup of a database, with compatibility level 80 (2000) running on SQL Sever express 2008 R2 and restore it on SQL Server express 2005?
I'm currently running into issues when taking that backup from SMO - I'm hoping that it is possible and I just may need to re-think my approach.
December 15, 2010 at 3:45 pm
It's not possible. Downgrade is not and never has been possible. The compatibility mode is totally irrelevant. The DB is attached to SQL 2008 R2 instance, it's a SQL 2008 R2 database.
Script, export, recreate DB on SQL 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
December 15, 2010 at 4:34 pm
Thanks for the response Gail,
I'll be dealing with possibly having to roll back locally installed databases, with numerous variations in schema. (I didn't create them!) I've never had much luck with scripting whole databases and recreating the database from the script. Are there any tools you'd recommend for this, or am I stuck with "Generate scripts..." from SSMS, redgate tools, and/or visual studio db tools?
December 15, 2010 at 4:41 pm
Jason Norsworthy (12/15/2010)
Thanks for the response Gail,I'll be dealing with possibly having to roll back locally installed databases, with numerous variations in schema. (I didn't create them!) I've never had much luck with scripting whole databases and recreating the database from the script. Are there any tools you'd recommend for this, or am I stuck with "Generate scripts..." from SSMS, redgate tools, and/or visual studio db tools?
The tools from redgate work quite nicely for this. The script option from SSMS also works very well. Those are the two options that I would recommend. You may also try to use Erwin if you have it.
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
December 16, 2010 at 2:38 pm
Jason Norsworthy (12/15/2010)
Thanks for the response Gail,I'll be dealing with possibly having to roll back locally installed databases, with numerous variations in schema. (I didn't create them!) I've never had much luck with scripting whole databases and recreating the database from the script. Are there any tools you'd recommend for this, or am I stuck with "Generate scripts..." from SSMS, redgate tools, and/or visual studio db tools?
I am curious - what issues are you running into with SQL Server 2008 R2 that are going to require rolling back to 2005? You need to be very careful with this - if there are any 2008 (or 2008 R2) specific features that were used, they will not work in 2005.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply