SQL Server Performance Forum – Threads Archive
Use COPY DataBase or Replication method? What diff
I would like to have a full backup from one server to another server<br />I have a production server with 75DBs and would like to replicate to another SQL server.<br /><br />Should I use the Copy Database or SQL Replication. I tried both but seem not successful<br /><br />– Copy Database Wizard –<br />—————————————————————————–<br />Your SQL server service is running under the local system account. You need to change your SQL server service account to have the rights to copy files over the network<br /><br />??What does it means<br /><br />– Database Replication Wizard –<br />—————————————————————————–<br />I ran the wizard in the source server and the following are created<br />1. a TstDistribution DB created in the server<br />2. a Replication Monitor–><img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />ublishers–>[SourceServer]–(no items)<br />3. under the Remote Servers, it created [SourceServer],<br /> [DestinationServer],repl_distributor<br />4. All database has a "shared hand" symbol attached on each database<br /><br />??Nothing happens on the [DestinationServer]<br />??Should I need to set some other things in order to replicate<br /><br />Should I use COPY DATABASE or SERVER REPLICATION<br /><br />Thanks in advance<br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />][<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />][<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />][<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />][<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]
SQL server service is running under the local system account. You need to change your SQL server service account to have the rights to copy files over the network
To use COPY DATABASE wizard between 2 machines the SQL service accounts must be started with a domain account with admin privileges or two accounts with same name as local admins on the box. If you want to have warm standby then you can use LOG SHIPPING which will take care of data using transaction log backups. I would go with REPLICATION in your case, even though its bit hard to setup.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Satya SKJ, can you highlight some steps that I need to be complete in order to have a full replications as I cannot manage to setup one[V][V]<br /><br />Thanks in advance[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />][<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br /><br />– Database Replication Wizard –<br />—————————————————————————–<br />I ran the wizard in the source server and the following are created<br />1. a TstDistribution DB created in the server<br />2. a Replication Monitor–><img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />ublishers–>[SourceServer]–(no items)<br />3. under the Remote Servers, it created [SourceServer],<br />[DestinationServer],repl_distributor<br />4. All database has a "shared hand" symbol attached on each database<br /><br />??Nothing happens on the [DestinationServer]<br />??Should I need to set some other things in order to replicate
Following articles for your reference to setup the replication:
http://www.databasejournal.com/features/mssql/article.php/1438231
http://www.databasejournal.com/features/mssql/article.php/1438201
http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000-Part-2/
http://www.mssqlcity.com/Articles/Replic/Replic.htm
http://vyaskn.tripod.com/repl_ans3.htm Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>