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

Replicating My SQL Server Expand / Collapse
Author
Message
Posted Wednesday, April 24, 2013 5:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:28 AM
Points: 3, Visits: 3
Dear All,

I have to prepare a backup server for my SQL Server, which should be automatically updated as the changes in main server.


I want to know can we do the same through Replication or by some other means.

Regards
Vishal Sharma
Post #1445855
Posted Wednesday, April 24, 2013 5:26 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:55 AM
Points: 5,989, Visits: 12,927
thats a big subject and the best answer depends on what the backup server will be used for and what latency you require.

You need to research clustering, database mirroring, logshipping and replication, possibly even SAN replication.

Database mirroring is dependant on this in fact not being SQL2000.

Post more details on your requirements and SQL version and we can steer you in the right direction.


---------------------------------------------------------------------

Post #1445866
Posted Wednesday, April 24, 2013 5:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:28 AM
Points: 3, Visits: 3
Dear sir,

I want to make a backup Server where we can switch when the main server is down again when the main server is up then it should automatically become the man server and they must me automatically syncronising the data.
Post #1445873
Posted Wednesday, April 24, 2013 6:58 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:55 AM
Points: 5,989, Visits: 12,927
I would suggest database mirroring

http://msdn.microsoft.com/en-gb/library/ms189852.aspx


---------------------------------------------------------------------

Post #1445926
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse