http://www.sqlservercentral.com/Content tagged T-SQL, Backup and Recovery, Miscellaneous, Programming posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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/