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?
Sql-server – Impact of Log backups restore process after file\file group restore on a database
backupfilegroupssql-server-2008-r2
Related Question
- Sql-server – Restore Verify Only w/ Transaction Log Backups
- SQL Server – Combining Log Shipping and Regular Log File Backups
- Sql-server – Transaction log backup file larger than expected
- SQL Server – How to Restore File Group from File Group Backup?
- Sql-server – How to choose which backup files to restore when identical timestamps exist for diff and log backups
- Sql-server – Log error restoring old database to SQL Server 2017
- Sql-server – Do Log Backups depend on Differential Backups
Best Answer
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.