It’s even possible to restore without creating a blank database at all. After connect to your SQL Server via SQL Server Management Studio(SSMS).
Do right click on “Databases” and select “Restore File & filegroups”.
MSSQL Server Restore File & filegroups
Restore Files and Filegroups Database dialog will appear, now enter your desired new database name in the “To Database” Text box as shown in screenshot below.
New database name in the “To Database” and select .”bak” file from resources
Now select source for restore “From Device”. Once you have selected your source database, SSMS will ask for the database “.bak” file. Select your “.bak” file and click on “add”.
You will see the “backup sets” List is updated with those that are contained in your selected .bak file. Now check the checkbox to use which backup data set you want to restore in your new database. See image below.
Click OK and refresh your database list to view changes.
By these you can restore database without even creating an empty database, as it is a gentle approach which is not required to go in to the “option” tab to check the “Overwrite the existing database” option.
Hope this helps!
3 comments
Yes! Finally someone writes about website.
Have you ever considered about adding a little bit more than just your articles?
I mean, what you say is important and all. Nevertheless
think about if you added some great photos or video clips to give your posts more, “pop”!
Your content is excellent but with images and clips, this website could undeniably be one of the very best in its field.
Wonderful blog!
I have read so many posts regarding the blogger lovers
but this post is truly a nice piece of writing, keep it up.