January 29, 2007 at 2:36 am
I tried detaching database from SQLServer2000 and ataching files (data and transaction log) to another server running SQL2005. It seems to work all right.
Are there any issues to be considered, any restrictions? Or is there some better way to move database?
Thanks a lot
February 1, 2007 at 8:00 am
This was removed by the editor as SPAM
February 1, 2007 at 1:55 pm
Really is only 3 ways I can think of that will convert a db from 2000 to 2005.
1) Detach and attach like you did
2) Restore a SQL 2000 backup to 2005 server
3) In place upgrade of SQL itself.
You could transfer all objects I suppose as a 4th alternative.
February 1, 2007 at 2:30 pm
To reduce the down time you restore backup/restore is the best option...
When you attach/restore your db, it will be compatibility 80 not 90. You need to change it...
Also run the DBCC DBREINDEX you have the time or you must run UPDATE STATISTICS...
MohammedU
Microsoft SQL Server MVP
February 1, 2007 at 2:35 pm
Not sure why backup/restore would be faster - with attach you just copy the file to whatever server and attach.
February 6, 2007 at 7:18 am
I'm not so familiar with these (DBCC DBREINDEX, UPDATE STATISTICS), please could you be more specific, what to do, and what is it for?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply