Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rswetnam
Starting Member
4 Posts |
 Posted - 2009-06-22 : 15:02:33
|
| Hi:I installed a copy of SQL Server Management Studio - Developer on my laptop and imported a database that I had developed as a 2005 Db. I believe that I updated the db to the 2008 variety and now am in the situation that I need a 2005 version of my database. I have created all sorts of new tables and stored procedures. Is there a way that I can roll back my db to a 2005 flavour so that I can combine it with the older version of the production database that is the 2005 variety?Any help appreciated.Roger |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-23 : 12:01:31
|
| No. You need to import/export your objects back to the 2005 server. Once you change your database compatibility mode to 100, you cannot restore the backup to a downlevel server.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Roll Back Database from 2008 to 2005