Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A better way
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Title:
Miscellaneous
Thread ID:
00489167
Message ID:
00490926
Views:
6
>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
Map
View

Click here to load this message in the networking platform