General information
Forum:
Microsoft SQL Server
>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
I believe using the MOVE keyword of the restore is the equivelent of the force resotore page in the EM.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only