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: Yesterday @ 4:52 PM
Points: 7,079, Visits: 12,569
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: Wednesday, July 16, 2014 2:50 AM
Points: 2,854, Visits: 3,174
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. 29 May 2014: now over 29,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