Home How toDatabase How to Restore Database without creating a new database in MSSQL Server

How to Restore Database without creating a new database in MSSQL Server

by wikky

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.

Select backup set to restore in the new database

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!


You may also like

3 comments

Zoe July 1, 2021 - 7:10 am

Yes! Finally someone writes about website.

Reply
Kendall July 1, 2021 - 6:55 pm

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!

Reply
Louvenia July 6, 2021 - 7:57 pm

I have read so many posts regarding the blogger lovers
but this post is truly a nice piece of writing, keep it up.

Reply

Leave a Comment

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More