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?
Who is Participating?
Aneesh RetnakaranDatabase AdministratorCommented:
It is better to create a backup of your exisitng database and restore it on the new server
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:
Hope thie helps.
All Courses

From novice to tech pro — start learning today.