http://www.sqlservercentral.com/Articles tagged Programming, Backup and Recovery posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)The second article in a 3 part series that presents another VBScript class file that creates a class that can be used to display the backup information from a SQL server's maintanence plans. http://www.sqlservercentral.com/articles/SQL-DMO/sqlbackups2/785/2003/08/28http://www.sqlservercentral.com/articles/SQL-DMO/sqlbackups2/785/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/Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book! http://www.sqlservercentral.com/articles/Administering/reviewofrealworldsqldmo/842/2002/11/19http://www.sqlservercentral.com/articles/Administering/reviewofrealworldsqldmo/842/Following up on a question posted in our discussion area, Andy demonstrates how to backup/restore a database using DMO, how to get the list of files to be restored, and how to do a restore with no recovery. Lots of sample code! http://www.sqlservercentral.com/articles/Miscellaneous/restoringusingdmogettingfilelistandnorecovery/823/2002/10/15http://www.sqlservercentral.com/articles/Miscellaneous/restoringusingdmogettingfilelistandnorecovery/823/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/