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

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

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

Whereas Oracle met the demands of mission-critical, 24/7 operation with features such as online re-indexing, snapshot-based restores, and fail-over log shipping, SQL Server couldn’t provide true ...

This week, I again had the opportunity to be on the Virtumania podcast with Rich Brambley, Marc Farley and a special SQL server guest, http://www.brentozar.com/ Brent ...

I'm looking for some insight into implementing replication with a SQL 2005 Standard database based on our needs as well as the fact that one major replication type is deprecated in SQL 2012 and ...