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

BANGALORE, INDIA: Your users expect your systems will stay up as much as possible. This would be in the face of unexpected events such as system failures as well as ...

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

I know this should work fine, I just want extra eye balls to make sure I'm not missing anything. I have a 2008R2 server that I'm planning to move a bunch of databases to a pair of SQL 2012 servers ...

For our new production environment, we're going to be using SQL 2005 and do log shipping from our main machine to a secondary machine. Part of this environment will include a migration process, which ...

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