October 4, 2006 at 3:50 pm
What is the easiest way to copy a database with all objects from one server to another and have servers be synchronized? The size of the database is approx 1 GB.
mmitchmcp
October 5, 2006 at 1:23 am
Detach the DB from main server, copy .mdf .ldf files to other server, then attach the main db & then new db as well, this is one way. The best way would be take the backup of the DB and restore on the other server.
------------
Prakash Sawant
http://psawant.blogspot.com
October 5, 2006 at 1:28 am
You can take backup of database through enterprise manager, copy .bak file to the other server and restore there from the same .bak file.
October 6, 2006 at 6:35 am
When you said "and have them be synchronized", were you talking about moving the data once, or were you talking about having both db's synchronized for reporting or high availability or whatnot?
Here's an article about 2 of the most popular HA/synchronization options...
-Luke.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply