3

When we restore file\file group(backup1) backup on a database is it necessary to restore all log backups that were taken after backup1 to get database in consistent state?? and also what will be the impact of log restore process on database state and those files?

2
  • 1
    Which DBMS are you talking about? May 3, 2014 at 22:04
  • SQL Server 2008R2
    – AA.SC
    May 4, 2014 at 11:47

1 Answer 1

1

When we restore file\file group(backup1) backup on a database is it necessary to restore all log backups that were taken after backup1 to get database in consistent state??

Yes - if you want to completely bring your database online (with all file groups) or you want to do a point-in-time restore of your database.

No - if you want to do a piece meal restore for specific file group.

I have explained in detail by giving an example at Backing up file groups with restore to earlier backup.

1
  • what I get is, 1. After restoring file group backup we can restore File Group transnational log\differential backup if we want to recover the file group with enough log to a stable point-in-time state. 2. and Impact of file group transnational log\differential backup restore will effect only the file group on which we are restoring backup and will not effect the other file groups.
    – AA.SC
    May 5, 2014 at 19:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.