http://www.sqlservercentral.com/Articles tagged Programming, Disaster Recovery, Strategies posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup. http://www.sqlservercentral.com/articles/SQL-DMO/sqldmorestore/118/2006/06/16http://www.sqlservercentral.com/articles/SQL-DMO/sqldmorestore/118/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/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/This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup. http://www.sqlservercentral.com/articles/SQL-DMO/sqldmorestore/118/2006/06/16http://www.sqlservercentral.com/articles/SQL-DMO/sqldmorestore/118/