Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

how to copy a MS SQL 2005 Server database to another MS SQL 2005 Server

expert: I am not a db type but I have a working database on one MS SQL 2005 Server and someone created a similar but blank database on another MS SQL 2005 Server. I want to know how to go about copying my existing database tables over to the blank database on the other  MS SQL 2005 Server and perhaps also the data?
0
tcmmaxt
Asked:
tcmmaxt
  • 2
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
It is better to create a backup of your exisitng database and restore it on the new server
0
 
pssandhuCommented:
I agree. The best way to do it is to BACKUP and RESTORE. Here is reference on how you can do that:
http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups
Hope thie helps.
P.
0

Featured Post

Industry Leaders: 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