• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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