Post reply

SQL Server Cluster with log shipping

  • September 6, 2004 at 10:17 pm

    #109236

    I have a database in a cluster server configure with active/passive setting, meaning sharing the same disk array. Obviously, if the other server went down the other server will take over. I'm planning to implement also a log shipping on the cluster server just to be sure there is a warm standby if the shared disk array went pfft and cannot be recovered (even it is a RAID array). Will it be possible to implement the log shipping over the cluster server? Assuming I have a spare machine to use. Or will I just implement a backup and restore to the standby server?

     

  • September 8, 2004 at 3:04 am

    #522070

    Yes, it is possible to do log shipping from a sql-cluster.

    Actually log shipping in no other beast as doing regular backups and restores...

    If you've got sql server enterprise edition you can use the inbuild log shipping mechanism, otherwise - or if you prefer knowing exactly what you are doing - you can implement ls by rote...

     

    Have a look at

    http://www.sql-server-performance.com/sql_server_log_shipping.asp

    regards

     karl

    Best regards
    karl

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

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