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?
tcmmaxtAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
It is better to create a backup of your exisitng database and restore it on the new server
0
 
pssandhuConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.