• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 489
  • Last Modified:

Move a database

Hi

I need to move a database from one server to another, is the best way to do this to back up the database, create a new databse of the same name in the new server and restore it from the original back up? If thats not correct van someone tell me the best way of doing t please?

Thanks
0
ac_davis2002
Asked:
ac_davis2002
  • 2
1 Solution
 
AnujCommented:
Backup and Restore is one way of doing this, another way is to detach the DB (mdf & ldf) from your original server and attach these files in new server using Detach\Attach method. Remember when you use any of these options, Server objects like Logins, Linked servers and SQL Server jobs etc are not transferred to the new server, you need to manually copy them using SSIS or another script method.
0
 
ac_davis2002Author Commented:
ok cool thanks alot. !
0
 
ac_davis2002Author Commented:
Excellent
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now