Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
1  
Which DBMS are you talking about? –  Colin 't Hart May 3 at 22:04
    
SQL Server 2008R2 –  AA.SC May 4 at 11:47

1 Answer 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.

share|improve this answer
    
thanks Kin.. this helped me –  AA.SC May 5 at 19:04
    
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 at 19:31

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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