Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore DB from an external drive
Message
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Backups
Title:
Restore DB from an external drive
Miscellaneous
Thread ID:
01687218
Message ID:
01687218
Views:
43
Hi,

How do I restore (override) the DB using SSMS where the backup .bak file is on the external drive?

Here is what I have done. I opened the SSMS, right mouse click on the DB and select to Restore -> Database.
The window Restore Database is open. The Source is [x] Database is checked and the name appears correctly.
The destination also appears to be correct.
But I cannot find where I specify the location of the .bak and the name of the .bak file?

TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Next
Reply
Map
View

Click here to load this message in the networking platform