Is there a way to way to choose the Force Restore option through SQLDMO. I am at a loss to find it if there is.

Sincerely,

Michael

>>I wish I could just rename the current database temporarily, restore new and then delete old.
>
>sp_renamedb
>
>It will rename the database but not the database files. When you do your restore, you have to use the MOVE option to change the name of the database files.
>
>-Mike