- 0
A SQL sort of problem...
-
Recently Browsing 0 members
- No registered users viewing this page.
-
Similar Content
-
Microsoft provides workaround for Windows apps broken by buggy SQL Server driver [Update]
By hellowalkman,
- patch tuesday update
- known issues
- (and 6 more)
- 0 replies
- 1 view
-
- 0 replies
- 5 views
-
SQL Server 2022 gets data virtualization, REST APIs with PolyBase
By Hamza Jawad,
- microsoft
- sql server 2022
- (and 5 more)
- 0 replies
- 3 views
-
SQL Server 2022 is the "most cloud-connected" release yet, now in preview
By Usama Jawad96,
- microsoft
- ignite 2021
- (and 16 more)
- 0 replies
- 2 views
-
- 0 replies
- 3 views
-
Question
Praetor
Hello all,
so I have this client that deleted some data from a production database and, for some weird reason that is beyond me, continued to use that database, having now newer data on it. :wacko:
so now I have, from a old backup, the data that it got deleted. My question, since I'm not an SQL expert, is it possible to join this data from the backup into the production database?
some info:
- it's a SQL Server 2008;
- it's only four tables and it doesn't have much data on them (only a couple of hundreds of lines).
- I have a backup that has the data that got deleted and I can make a new backup of the production database just before I touch it.
- the client used a stored procedure to delete the data.
my biggest fear in this situation is that there are relationships between the tables and if I just insert the missing data it creates new primary keys (it is auto-incrementing), making other tables that depend on that data broken :/
Is there any quick solution for this mess?
Link to comment
Share on other sites
3 answers to this question
Recommended Posts