RE: SQL Server disaster recovery - advice about AppAssure

SSC Guru

Points: 323504

May 8, 2013 at 11:11 am

remind him about partial data recovery and point in time restores.

the little bit i read says NIGHTLY backups, and does not mention SQL Server point in time recoveries throughout the day.

if something goes wrong late in the day, can the business lose the entire days data to last nights restore?

For partial point in time restores, you need the native full + transaction log backups so you can restore to a new database and MERGE data to fix those issues like when someone accidentally inserts/updates one specific table's worth of data, and that's the only thing you have to recover.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!