June 21, 2008 at 4:55 am
Hi.
We stopped the SQL 2000 Server on the old server. Copied over the mdf files to the new SQL 2005 Server and then attached the mdf files. This way new ldf files where created.
Can you confirm that we did not loose any transactions in this process? I mean because we did not move the ldf files to the new server.
Best Regards
Arnt O. Kvannefoss
June 21, 2008 at 6:45 am
You probably haven't lost any data but that's not the recommended wy of migrating, why did you not move the ldf files too?
Gethyn Elliswww.gethynellis.com
June 21, 2008 at 6:51 am
We did not move the ldf files, because we had 1 500 hundred databases to move. This from a very slow server. The detach process would have taken a very long time. For the attach process we modified the great script from Wynn Muse, found on this site. 🙂
Best Regards
Arnt O. Kvannefoss
June 21, 2008 at 8:57 am
You can try the below query to detach all the user databases.
I hope you won't loose any transactions since when you stop sql server all the uncommitted transactions will be rolled back \ forward, better copy log files also!!
Regards..Vidhya Sagar
SQL-Articles
June 21, 2008 at 9:56 am
If you stopped the server, you should be alright as mentioned above.
What you did makes sense with that many databases and this should have speeded up the process. The thing you want to do is be sure that your new files are the same size as the old ones so you don't have a bunch of auto-growing occurring as activity takes place on the new files.
June 23, 2008 at 1:18 am
Vidhya, thanks a lot for the script. Please explain when uncommitted transactions could be in the log file and been rolled back.
Steve, thanks for the tip on the log files size. I will have a lock at it.
Best Regards
Arnt Kvannefoss
June 23, 2008 at 10:03 am
Why can not you use the Backup and Restore option. It's not a best practice that you can move the mdf file over the network to the new server.
Backup and Restore is the Best Practice recommnaded by MS and then Detach and Attach.
MCP, MCTS (GDBA/EDA)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply