Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restore a database
Message
De
21/03/2019 10:10:38
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Divers
Thread ID:
01667416
Message ID:
01667459
Vues:
34
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform