Our client will ship a database full dump on day 1 and daily transaction log from day 2. We will restore the full dump on day 1 and plan to restore the transaction log daily since day 2. Is it possible to just restore the daily transaction log? Because I read in order to restore a transaction log backup, the database has to be in a restoring state which means that a full backup or a full backup and differential backup were first restored using the NORECOVERY option to allow additional backups. Does it mean on everyday in order to restore the daily transaction log we have to first restore the full dump and leave the db in NORECOVERY mode and restore all the transaction logs before current day and leave the db in NORECOVERY mode?
Sql-server – Daily restore from sql server transaction log
sql server
Related Question
- Sql-server – The purpose of transaction log in Restore First
- Sql-server – The log in this backup set is too recent, but it’s from before the last full backup!
- Sql-server – Errors restoring a differential backup
- Sql-server – How to recover from a failed SQL Restore
- Sql-server – How to restore a transaction log
- Sql-server – SQL Server High Availability restore copy_only backups from secondary replica problem
- Sql-server – How to choose which backup files to restore when identical timestamps exist for diff and log backups
- Sql-server – SQL Fast database restore with Azure Virtual Machine instant recovery snapshot and SQL in Azure VM
Best Answer
As you already pointed out, restoring just the transaction log is NOT possible you have to either restore full backup or full and differential backup to restore transaction log backups.
Yes. Are you aware about transaction log shipping this might suit your requirement.