Menu
I have written a log shipping program a number of times. It is a simple program that is used to maintain a warm fail over box for SQL Server.
It has two pieces. On the live dB server it:
On the backup server it:
If there is a failure, the program can go through each database on the backup server and set them to active.
I am looking for an open source or low cost program that does this.
212
Log Shipping::It provides a warm standby solution that has multiple copies of a database and require a manual failover. Mirroring::When a database mirroring session is synchronized, database mirroring provides a hot standby server that supports rapid failover without a loss of data from committed transactions.
Some of the problems with log shipping include: + Log shipping failover is not automatic. The DBA must still manually failover the server, which means the DBA must be present when the failover occurs. + The users will experience some downtime.
No, log shipping to Managed Instance is not possible; it only supports the restore of full backups.
MS SQL server 2005 and 2008 already support this.
http://technet.microsoft.com/en-us/library/ms188698.aspx
http://technet.microsoft.com/en-us/library/ms188698(SQL.90).aspx
61
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
