Hi:
I have a MSSQL 2005 database in current server, since we are going to shift to another server, I need to copy the database to the new server for testing.
Can you please let me know what is the best way to do that? I have tried to use detach and attach, or "back up the database and then restore on the other server.", but seems not working for me. I want step by step instruction since I am pretty new for the DB migration.
Thanks.
Jt
Hello Jt,
Do you know why the detach/attach and backup/restore are not working properly? They are created to do these kind of actions.
Have a look at the following article to move a database with attach/detach:http://support.microsoft.com/kb/224071
or to do the restore:http://msdn2.microsoft.com/en-us/library/ms186390.aspx
|||Have a look atthis post on Scott Gu's blog, detailing the use of the recently releasedDatabase Publishing Wizard. It explains how to transfer a database schema and/or it's data to another server. It basically outputs a script file containing all the commands, which you would then save and execute on the server you wish to transfer it to.
Hope that helps.
No comments:
Post a Comment