Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

best replication method for large database Expand / Collapse
Author
Message
Posted Monday, April 1, 2013 1:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 1, 2013 1:24 AM
Points: 1, Visits: 5
What is the best replication method for large database?
thanks
Post #1437367
Posted Monday, April 1, 2013 11:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 4:51 PM
Points: 7,097, Visits: 12,597
It depends on the requirement. What are you trying to do? How fresh does the data need to stay? Is there a fast network link between the involved databases?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1437549
Posted Tuesday, April 2, 2013 2:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 2,867, Visits: 3,209
There is no 'best' method to replicate a database based on its size. There may be a 'best' method depending on what the business requirements are.

If this is a real-life question (not an exam or interview question) then let us know what problem you are trying to solve and maybe we can help you.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1437748
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse