Activity overview
Latest activity by ftaute
OK thanks, another nail in the 'migrate to 2008 coffin' [image]
Fred / comments
OK thanks, another nail in the 'migrate to 2008 coffin'
Fred
hmm, I now see where the LSN pollution is coming from. We have a separate backup that is called from a sql agent job daily in the morning, and the diff is keying off the checkpoint_LSN from that backup.
However, we are trying to use the weekly full and daily diff from the sql backup toool to streamline file copying to an offsite location, and so trying to keep the files on weekdays smaller, with the larger full backup being done on the weekend when it is possible to move it without interfering with other bandwidth demands.
Is there a way to modify the diff job to key off the LSN from that one specific weekly full backup then?
thanks a lot
Fred / comments
hmm, I now see where the LSN pollution is coming from. We have a separate backup that is called from a sql agent job daily in the morning, and the diff is keying off the checkpoint_LSN from that ba...
thanks Peter, here are the LSN's - I dont see any correlation but poking around among the other backups on dbs where the restore does work, I see that the full checkpoint LSN matches the diff dbbackup LSN.
ID file first_lsn last_lsn checkpoint_lsn database_backup_lsn
1258 FULL_(local)_Practiceadmin_20090207_181027.sqb 255693000002340800001 255693000002471900001 255693000002340800035 255431000001163200099
1594 DIFF_(local)_Practiceadmin_20090212_180851.sqb 257122000001116500038 257122000001159100001 257122000001116500038 256975000001127700024
thanks again
Fred / comments
thanks Peter, here are the LSN's - I dont see any correlation but poking around among the other backups on dbs where the restore does work, I see that the full checkpoint LSN matches the diff dbbac...
Diff Restore Fails with SQL error 3136
I have a SQL2000 production database which will not restore from a diff or trans log backup to a new db. Exits with sql backup exit code 1100, sql error 3136 after it has restored the full backup. ...