Home Forums SQL Server 7,2000 General Diff backup and Tran Log at the same time RE: Diff backup and Tran Log at the same time

  • We tend to disable our transaction log backups during full and differential backups (also reindex jobs and DBCC checks), but that's mainly due to a set of jobs we have to notify us if there's any blocking going on in the database, obviously you can't do two backups at the same time so the one started last is blocked from being ran till the first one completes.

    You can build in steps to disable the jobs automatically and re-enable them in the same way, i can send you details if you're interested.