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 |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2008-11-05 : 17:53:37
|
| Guys,i am trying to move database from from sql 2000 instance to sql 2005, for this move I am planning to use detach from SQL 2000 and attach to 2005 process instead for backup and restore.Are there any issues with attach and detach process acorss different versions. Any suggestions and inputs would help.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-11-05 : 19:00:43
|
| If you have any READonly database make it READ/Write before detach and make sure all filegroup/datafiles are set to READ/WRIte. If there is any READ only filegroup. While ataching to different version it updates database headers and objects and in case of READ only you may constantly get error. |
 |
|
|
|
|
|
Upgrade to SQL 2005