-
- Enthusiast
- Posts: 37
- Liked: 7 times
- Joined: Nov 23, 2015 4:47 pm
- Full Name: VanillaMastermind
- Contact:
SQL Server - How to restore a table over existing table
I am testing out different SQL Server recovery scenarios in Veeam B&R. I have gotten all kinds of different restores to work with the exception of one that seems important. I can't find a way to recover a single database object right over the top of the existing one. I can recover the entire database over itself (via RESTORE DATABASE), and can recover individual database objects to the same (or different) database with a DIFFERENT NAME (via RESTORE SCHEMA), but I can't seem to restore an object over the top of itself with the same name. If I try to make the name the same, I get the error "Object with the same name already exists in database: [DATABASE NAME]" Is this not possible? If not, I am still satisfied as I can work around it on the SQL Server level, but I was surprised to not see an option that allows that, with Veeam B&R being so flexible.
-
- Product Manager
- Posts: 6408
- Liked: 724 times
- Joined: May 19, 2015 1:46 pm
- Contact:
Re: SQL Server - How to restore a table over existing table
Hi,
VBR cannot replace an original object with the one from backup and that's by design. Imagine if you chose to restore (via replacement) the wrong object and did not have the most recent db backup at hand, in this case your data would be unrecoverably lost.
Thank you.
VBR cannot replace an original object with the one from backup and that's by design. Imagine if you chose to restore (via replacement) the wrong object and did not have the most recent db backup at hand, in this case your data would be unrecoverably lost.
Thank you.
-
- Enthusiast
- Posts: 37
- Liked: 7 times
- Joined: Nov 23, 2015 4:47 pm
- Full Name: VanillaMastermind
- Contact:
Re: SQL Server - How to restore a table over existing table
That makes sense. Thanks for the quick response!
Who is online
Users browsing this forum: BackupBytesTim, Semrush [Bot] and 280 guests