Replicating My SQL Server

  • 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

  • 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.

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

  • 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.

  • I would suggest database mirroring

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

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

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

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