http://www.sqlservercentral.com/Content tagged Disaster Recovery, Backup and Recovery posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)SQL Server has a great backup and recovery architecture, but you have to know how to properly configure and use the server to ensure that you will not be seeking new employment anytime soon. A few of the Sonasoft team have written this short piece on strategies for setting up your backup jobs to ensure recovery in the event of a disaster. Welcome new authors Bilal Ahmed, Kiran Kumar, and Vas Srinivasan. http://www.sqlservercentral.com/articles/Disaster+Recovery/backupscenariosforsuccessfulsqlserverrestoresandre/1421/2004/06/29http://www.sqlservercentral.com/articles/Disaster+Recovery/backupscenariosforsuccessfulsqlserverrestoresandre/1421/This articles makes the case for using SQL LiteSpeed over other backup solutions and presents some notes about why the DBA should manage backups rather than offloading to network administration. http://www.sqlservercentral.com/articles/Administering/integratingsqllitespeedinyourexistingbackupinfrast/986/2003/05/12http://www.sqlservercentral.com/articles/Administering/integratingsqllitespeedinyourexistingbackupinfrast/986/Andy had a semi-disaster similar to the one he wrote about last year. Interesting to see the kinds of problems that happen to other people. This article raises some interesting points that are outside the scope of basic disaster recovery, looking at how/when to move databases to a different server and how to reduce the server load dynamically. http://www.sqlservercentral.com/articles/Administering/anotherdisasteralmost/881/2003/01/14http://www.sqlservercentral.com/articles/Administering/anotherdisasteralmost/881/This article analyzes the various options available for your backup and recovery process with SQL Server 2000 as well as an enhancement to your SQL Server backup and recovery process using a highly efficient backup and restore utility that provides significant time and disk space savings called SQL LiteSpeed. http://www.sqlservercentral.com/articles/Administering/backupandrestorebacktobasicswithsqllitespeed/884/2002/12/23http://www.sqlservercentral.com/articles/Administering/backupandrestorebacktobasicswithsqllitespeed/884/Are you tired of manually restoring each database on a new server when the original server has a melt down? Does the manual process seem slow, and prone to keystoke and mouse click errors? Would you like to have those restore scripts automatically built, so you only have to fire them off? Well this article will show you one possible method for speeding up and reducing errors will trying to perform a restore of all databases on a server. http://www.sqlservercentral.com/articles/Disaster+Recovery/streamliningtherecoveryprocess/837/2002/11/05http://www.sqlservercentral.com/articles/Disaster+Recovery/streamliningtherecoveryprocess/837/A VBscript class is created that can be used to query the maintenance plans on an SQL server to determine when a backup has occurred. This class can be used with others to create a scripted method for monitoring backups. http://www.sqlservercentral.com/articles/SQL-DMO/sqlbackups1/783/2002/08/22http://www.sqlservercentral.com/articles/SQL-DMO/sqlbackups1/783/Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day. http://www.sqlservercentral.com/articles/Administering/disasterintherealworld2/747/2002/07/31http://www.sqlservercentral.com/articles/Administering/disasterintherealworld2/747/