Replicating My SQL Server

  • vishvaain2005

    SSC Rookie

    Points: 31

    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

  • george sibbald

    SSC Guru

    Points: 104200

    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.

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

  • vishvaain2005

    SSC Rookie

    Points: 31

    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.

  • george sibbald

    SSC Guru

    Points: 104200

    I would suggest database mirroring

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

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

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply