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 |
|
edimen
Starting Member
12 Posts |
 Posted - 2010-07-22 : 13:41:36
|
| Hello,I need to move a database from a SQL 2005 SP3 CU7 server to a SQL 2005 RTM server - is this something that should work, are there any possible issues with that?Thanks in advance! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
edimen
Starting Member
12 Posts |
Posted - 2010-07-22 : 14:44:28
|
| Would detach/attach work as well? Or database copy wizard?Also, if detaching, is that a good idea to have 'update statistics' on? That won't make the database incompatible in any way with the RTM server?Thanks!!! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
edimen
Starting Member
12 Posts |
Posted - 2010-07-22 : 14:55:41
|
| Tara - Thanks so much for the advice! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-07-22 : 16:59:08
|
| I would rather prefer backup/restore than detach attach as detach/attach carries very high risk.. if your DB detaches and will not attach properly or has some errors then you are screwed... on the other hand if your backup wont restore properly you can take another backup.. or figure out something.. at least you will have access to your db on the CU server..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
Moving a database from SQL2005 SP3 to RTM