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 |
|
dhanyabala
Starting Member
1 Post |
 Posted - 2011-12-21 : 06:23:43
|
| Please help me to provide a proper way for the following issue I have faced:I am using Sql Server 2008 R2 & I took back up file of it & try to restore it in client siteWhich has Sql Server 2008. But I was not able to do it as it showed compatibility issue error.I tried many other options like tried with “Generate Script, changing script for server version”,Tried exporting data, etc.But none of those worked fine. When I try to restore using script, as it is aHuge database, I had some data loss & it took a very long time. I also tried changing Compatibility level of my database. Can I change compatibility level of my database perfectly? Or is there other methods?Please suggest me a better & efficient option to restore database from higher Version, Sql Server 2008 R2 to lower version , Sql Server 2008 .Thanks a lot. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-21 : 09:41:58
|
| Script all objects, export all data, recreate the DB on the lower version. That's the only way you'll get it down. Don't try scripting the data unless the DB is a couple of MB. Export it (SSIS, bcp)Compatibility level is purely for the query processor and it's about what SQL is valid and legal, it does not affect the internal database version.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Sql Server Restoring back up issue