Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore a database
Message
From
21/03/2019 10:10:38
 
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
01667416
Message ID:
01667459
Views:
33
>Ok. So far, I was able to restore the .bak copy of the SQL database into a different name database.
>
>Could I have, also, restored the .bak copy right into the "damaged" database? That is, if I selected the current "messed up" database and clicked on Tasks -> Restore and then pointed to the MyDatabase.Bak, would it replace the existing database with the one in the .bak?

That would be a regular restore. I do not think SQL Server does any kind of verification to see if the actual database is corrupted before restoring over it.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform