Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can I restore from .BAK file without any other
Message
De
28/11/2009 13:50:33
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01436834
Message ID:
01436842
Vues:
51
This message has been marked as a message which has helped to the initial question of the thread.
>>
>>
>>Start SSMS.
>>In Object Explorer, right click on Databases and select Restore Database.
>>IN "To Database" write the name of the database (new one).
>>
>>Other way.
>>Just create a DB with the same name before restore the backup file.
>
>I have another question, if I may. I get error on the SSMS Restore Database window:
>
>
>Restore Failed.
>System.Data.SqlClient.SqlError: Directory Lookup for the file "C:\Program Files\Microsoft SQL
> Server\MSSQL\Data\NameofDatabase.mdf" failed with the operating system error 3(The System cannot find the
>path specified)
>
>
>Note that I placed the NameofDatabase.bak file in another directory to which I am pointing in the field "Specify the source and location of backup sets .. From Device". And I see three backups in the grid below.
>
>What am I missing? Must I place the .bak file into the directory identified with the error above?


The path where you placed the BAK file didn't matter.
The path where you just created NameOfDatabase did :-).
If you choose second method, then you should rioght click on Database name And:
Tasks->Restore->Database.
And if you have more than one Backups in that BAK file you must choose the recent one. Just mark the one with recent datetime. Alsom you must go to the Options Node of treeview and check "Overwrite ...."
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform