Hi,
just played around with restoring my MS SQL databases and found the following:
- Start database restore (agent on SQL-Server, using B&R), complete database restore
- Get the following message: Database XY will be restored back to server BLUBB to the latest available state of ... If present, existing database files will be deleted.
OK, let's go! Indeed, Veeam deleted the existing database. Now, for some reasons, restore of the database fails. In my case, just a Windows firewall issue, no problem at all. But... in other cases, the existing database will be lost and I'll have to pray that I got other options to get my database back. Restoring the database doesn't have to mean that my existing database isn't working anymore, maybe it's just outdated a little bit.
Wouldn't it be nice to have a little insurance that the restore will work before something is deleted and gone completely? Or am I wrong here?
Regards,
Jens
-
- Enthusiast
- Posts: 78
- Liked: 9 times
- Joined: Mar 04, 2013 2:41 pm
- Contact:
-
- Product Manager
- Posts: 9848
- Liked: 2607 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: Restore SQL database. Delete? Oh yes, it does!
Hi Jens
In case you want to do a restore without removing the old database first because you still require some data from it or want to check if the restore is working, you can always restore the data to a new database with a new name, instead of overwriting the original one.
Also, if the old database contains working tables, and your plan is to restore only a small part of the data, you can use our item level recovery features to select the objects you want to restore:
https://helpcenter.veeam.com/docs/backu ... ml?ver=110
Also, I suggest testing restores of your backup on a regular base, so that you don't face the same situation when you have a real restore outside your lab to-do.
Thanks
Fabian
If you restore to the original location, the old database will be removed. That's correct. We need to remove the old database files in order to be able to write the new ones.Restoring the database doesn't have to mean that my existing database isn't working anymore, maybe it's just outdated a little bit.
In case you want to do a restore without removing the old database first because you still require some data from it or want to check if the restore is working, you can always restore the data to a new database with a new name, instead of overwriting the original one.
Also, if the old database contains working tables, and your plan is to restore only a small part of the data, you can use our item level recovery features to select the objects you want to restore:
https://helpcenter.veeam.com/docs/backu ... ml?ver=110
Also, I suggest testing restores of your backup on a regular base, so that you don't face the same situation when you have a real restore outside your lab to-do.
Thanks
Fabian
Product Management Analyst @ Veeam Software
-
- Veeam Software
- Posts: 3626
- Liked: 608 times
- Joined: Aug 28, 2013 8:23 am
- Full Name: Petr Makarov
- Location: Prague, Czech Republic
- Contact:
Re: Restore SQL database. Delete? Oh yes, it does!
Hello,
Basically, it's an interesting question: what is the reason to perform in-place database restore if you still need the production database to be up and running? Maybe it's just my subjective perception but I will agree with database deletion only if I don't need this database at all. However, if I need to continue working with the original database, I will select a different location for restore as Fabian has said.
Thanks!
Basically, it's an interesting question: what is the reason to perform in-place database restore if you still need the production database to be up and running? Maybe it's just my subjective perception but I will agree with database deletion only if I don't need this database at all. However, if I need to continue working with the original database, I will select a different location for restore as Fabian has said.
Thanks!
Who is online
Users browsing this forum: No registered users and 6 guests