Activity overview
Latest activity by joshbond
I performed a DIFF backup right after my FULL and BAM! 18.0GB. Is there some way to examine a DIFF file and see what is in there?
This is craziness! / comments
I performed a DIFF backup right after my FULL and BAM! 18.0GB. Is there some way to examine a DIFF file and see what is in there?
This is craziness!
The transaction log backup made no difference. I disabled my reindex job. So the order of events was:
Transaction log backup @ 10:45PM
Full backup @ 11:00PM ~ 50GB compressed
Transaction log backups every 15 minutes for 24 hrs ~ 1.8GB compressed in total
Diff backup @ 11:00PM ~ 18GB compressed
It is acting like I should always have a minimum of 17-18GB (compressed) in my differential backup. Something is really, really wrong and I cannot figure it out. / comments
The transaction log backup made no difference. I disabled my reindex job. So the order of events was:
Transaction log backup @ 10:45PM
Full backup @ 11:00PM ~ 50GB compressed
Transaction log backup...
It's the newest Service Pack or close to it. 9.0.4.053
I really think it might have to do with the transaction log. I am going to try to run a transaction log backup after the reindex and see if that makes a difference. / comments
It's the newest Service Pack or close to it. 9.0.4.053
I really think it might have to do with the transaction log. I am going to try to run a transaction log backup after the reindex and see if th...
I am using SQL Server 2005. The database is not compressed.
Do you perform a transaction log backup after your reindex job and before the FULL backup? / comments
I am using SQL Server 2005. The database is not compressed.
Do you perform a transaction log backup after your reindex job and before the FULL backup?
Trouble with differential backups
I am using SQL Backup 6.2.0.134. I create a FULL backup of my 164GB database every Friday night. Sa-Th I create a DIFFERENTIAL backup. My problem is that the first DIFFERENTIAL backup (Saturday) is...