SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Disaster Recovery for SQL Server Databases


Well, it finally happened, the complete disaster recovery article was reviewed, reviewed again, rewritten, revisited…you get the picture…and published.  As described by my cousin, this is an Open Source Disaster Recovery Solution for SQL Server Databases. Originally, the work was personal reactionary attempt to better SQL Server Replication (which I had lived through nightmares with prior) by means of a what I consider to be the most reliable storage replication, now it's onto Database Mirroring in the current mandate to see how it compares with the latter.

Thank you so very much to Chris Massey and Andrew Clarke for their great help, and to Brad McGehee for pushing me in the SSC first, and ultimately, the Simple-Talk.com direction.  

The full English version is finished et une traduction en français est déjà en cours (disponible d'ici la fin septembre/début octobre).

Enjoy, and looking forward to your comments!

http://www.simple-talk.com/sql/backup-and-recovery/disaster-recovery-for-sql-server-databases-/ ( and currently front page of Simple-Talk.com )

 South Coogee Cliffs - early morning 1990, while working as Moving Jockey (Aussies say Removals ) for Austwide

Don't be caught without a DRP, it could mean your companys' operations end up washed up on the rocks. 

Pictured here is one of the first panoramas (albeit only two shots taken with the old '71 Pentax Spotmatic 2) I've ever taken at 15 years, at South Coogee Cliffs, Sydney - early morning 1990, while working as Moving Jockey (Aussies say Removals ) for Austwide Removals, Gary Buter's old company. Gary was my host in Melbourne at the time, allowing me to share his great flat in St. Kilda while attending Elwood High School.


Posted by Phil Factor on 4 September 2009

It is very fine article too.

For a lot of DBAs, the task of producing the required documentation looms much larger than it needs to, and so I believe it is vital to have samples and templates of standard documents available.

A lot of professions are beset by mounting paperwork. Teachers, for example have far more planning and documentation to do now and much less time to do it. In Britain, they have countered by providing a vast resource of standard documents on the internet. It is far easier to alter a standard, pre-existing document than to prepare one from scratch.

Why can't we DBAs do the same thing? On Simple-Talk they've made a start with this and Change-Management, but there must be a lot of pretty standard documents that could get the same treatment. Suggestions anyone? There must be a host of standard documents that are required by DBAs and developers which would be more easily produced from a standard template.

Beaucoup de gens seraient heureux de lire une version du document qui est écrit dans la langue française. Je me réjouis de ce même si je ne serais pas en mesure de parler la langue, même si elle était nécessaire pour sauver ma vie.

Posted by Hugo Shebbeare on 4 September 2009

Thank you Master Phil Factor, I do my best to please both linguistic communities when I can. Un dia, quando tengo mas tiempo y dinero, una copia en Espagnol viene tambien.

Regarding templates, glad you mentioned that. I have also made an attempt to provide a Microsoft Project Template for Migrations also, in this post:

www.sqlservercentral.com/.../microsoft-project-migration-template-for-the-move-to-sql-2008.aspx  I just need to update it thanks to input from Brent Ozar.  The current file is here: www.intellabase.com/ProjectTemplate_Production_DB_Migration_SQL2008.rar

I also have a bilingual generic COBIT template for Change/Risk Management which will be uploaded for my next post. While consulting for Dell/Nexio at Tata Telecom in 2007, these change management documents were really a gift from above, and ensured that the environment was controlled - and considering the almost eighty thousand resources at TCS' disposition, you can imagine the absolute requirement to do so.

Leave a Comment

Please register or log in to leave a comment.