SQL Server Performance

Use COPY DataBase or Replication method? What diff

Discussion in 'Performance Tuning for SQL Server Replication' started by kpyeung, May 27, 2004.

  1. kpyeung New Member

    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--&gt<img src='/community/emoticons/emotion-4.gif' alt=';P' />ublishers--&gt;[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=':)' />]
  2. satya Moderator

    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.
  3. kpyeung New Member

    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--&gt<img src='/community/emoticons/emotion-4.gif' alt=';P' />ublishers--&gt;[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
  4. satya Moderator

    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.

Share This Page