So you decided to set up log shipping in order to establish a failover server, but what's next? Log shipping only takes care of keeping a user database in sync from one server to the other. In the ...

A standard way to provide for database-server disaster recovery is to prepare a standby server — a secondary database-server computer that maintains a somewhat current version of your production ...

Log Shipping in SQL Server has been around for a while and still provides an easy method for redundancy and load balancing. It uses standard backup and restore technology to ship backups to a standby ...

B上的一个SQL JOB执行sp_log_shipping_monitor_backup得到如下错误信息: Msg 14420, Level 16, State 1, Procedure sp_log_shipping_monitor_backup, Line 73 The ...

SQL Server 2005 also promises better performance. I didn’t run performance benchmarks for this review, but in addition to allowing DBAs to partition the database to balance load, Microsoft has done a ...