I do hourly LOG backups on my db
backup database directory 'c:\dbBackup\logs\...' transaction log only
I truncate the log file once a week ( monday backup )
This log file contained everything from mon unit 2 in the afternoon on fri
The db died because we ran out of disk space
I took the thursday night backup and tried to apply the fri 14:00 log, i got an error message telling me the log was the wrong size.
When I applied the log from the corrupt db, it restored the thursday (backup) db as expected.
What is the correct procedure for doing incremental backups and restoring from them?
Have a look at this doc if it helps. http://www.sybase.com/files/White_Papers/SQLA_SA_backup_070307-wp.pdf
answered 07 Aug '12, 14:01
AFAIK, in general, one should apply the translog from the full backup first to bring the database to the state of the end of the full backup (say, too apply transactions that were running while the backup took place). Have you tried this first?
Then, at second step, you should apply the newest translog, i.e. the one from Friday 14:00.
answered 08 Aug '12, 10:45