October 31, 2011 at 8:26 pm
hi
i did some major changes to data in a DB ,so before i did it i did a full backup via the SQL Server managemtn tool now a month later the ownerr decided to revert all the changes, my problem is if i do a resotre from the the bak file it will overwrite all the new data we had add it in the last month
my question is how do i do a full restore from the bak file but not overwrite the new data
Pleasae help
November 1, 2011 at 1:35 am
Your question is a bit weird. If I can understand correctly, then you need only some specific tables data to be in original state. Right? If this is the case and you have static data in those tables, then you can get that data back. Take backup of the current DB. Restore that current backup and one month old backup as new DBs (do not restore on the current DB) and compare the data in tables for both Databases. For this Data compare you can use Red Gate's "SQL Data Compare" or any other tool. This way you can easily identify the previous and current data and then compare that difference in data with the changes you made manually. If the data comparison and your changes are the same, then you can replace current DB's specific tables specific data (specific rows which you updated manually) with restored DBs data (old data). This way you will keep the new inserted data (SQL Data Compare will help you out on this as well). My recommendation would be to do this exercise in a testing environment and after you are 100 percent sure (which I guess is not possible 🙁 ), then move to production environment. Do take backups of the current DB before replacing any data and also after the changes you make.
But if your data was not static, and frequent updates/inserts were done. Then you have to do kind of data mining and it purely depends upon your environment i.e. backup types, frequency etc.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply