This month’s T-SQL Tuesday is hosted by Allen Kinsel (Blog|Twitter) and covers “disasters and recovery”. My favorite DR solution is mirroring. Mirroring is easy to setup and fast, if implemented properly. It’s a database level solution that allows you to keep a remote copy of your database in sync with your principal database. Everything is [...]
Ryan Adams Blog
SQL, Active Directory, ScriptingSQLServerPedia
Browsing Posts tagged Disaster Recovery
How to set SQL Mirroring TIMEOUT and 2 scenarios where you want to.
Mirroring: The Bear Necessities slide deck and sample code
Ryan Adams will be doing two presentations on SQL Mirroring this week.
You cannot mirror a database to two seperate servers, but there is an alternative.
Here is how to automate copying your SQL logins to your DR server.
How to automate restoring SQL database backups to your disaster recovery server.
