Red Gate forums :: View topic - SQL DataCompare to restore data lost on server from backups
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

SQL DataCompare to restore data lost on server from backups

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
kinano



Joined: 28 Jul 2011
Posts: 3

PostPosted: Tue Oct 18, 2011 2:16 pm    Post subject: SQL DataCompare to restore data lost on server from backups Reply with quote

I have the following scenario for which I'd like to pick your brains a little.

We have a DB server that had performance issues on Friday. The db server was mirrored. We had originally switched the mirror server to become the online master. However, we discovered that the mirror server had some discrepancies with the master server in terms of schemas. After a few hours, we had to restore the master DB server to a stable state from the full backups taken on Friday just before the lag was observed.

Hence, we have potentially lost some of the data collected after Friday.
I am thinking we could use SQL Data Compare to get the differences in Data between the restored master DB server and the latest backup files we have in place and hence restore as much data lost after Friday as possible.

My questions follows:
It seems that SQL Data compare supports comparing db objects in an online database to a backup file directly with no problem. Would the comparison work only for full backup files or can we also use transaction logs backup files to make the comparison in increments if needed?

I realize you may need more information to answer this. Please let me know if you have any questions.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Thu Oct 20, 2011 5:22 pm    Post subject: Reply with quote

Thanks for your post - if you need a quick answer it's usually best to email support@red-gate.com directly, as we're only alerted to unanswered posts automatically after a day or so.

As for your query, SQL Data Compare only works with full backups, so if you need to access the data from later transaction logs, I guess you'd need to restore the database + logs to a new temporary DB and then work with that from within Data Compare.

Hope that helps,

James.
Back to top
View user's profile Send private message
kinano



Joined: 28 Jul 2011
Posts: 3

PostPosted: Thu Oct 20, 2011 5:43 pm    Post subject: Reply with quote

Makes perfect sense. Thank you for the reply.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group