CODEWITHSUNDEEP
sql-serversql-server-2016
xcrookedxedge
xcrookedxedge

Reputation: 51

Does an Database restore to a new Destination affect the original Database?

Today i recognized that last week I made an horrible mistake. I truncated a very important Table. Good for me, i have a Backup-File before the truncation.

My Question now is:

Can i restore this Backup-File to a new Database without affecting the original (the one i truncated the table) Database or isn't this possible?

Software: SQL Management Studio 2016 and SQL Server 2016

Kind regards.

Upvotes: 0

Views: 821

Answers (1)

DrHouseofSQL
DrHouseofSQL

Reputation: 546

Can i restore this Backup-File to a new Database without affecting the original (the one i truncated the table) Database or isn't this possible?

Yes you can as long as you are in fact restoring the backup to a new database. The concern I have now is that today you realized you made a mistake last week. Once you restore you need to focus on copying/importing the data from the table prior to truncation to the table post truncation. All of this while ensuring you keep the rest of the data up to date (making sure you aren't overwriting.

Upvotes: 1

Related Questions