cancel
Showing results for 
Search instead for 
Did you mean: 

When To Run SQL Transaction Logs

Thundercleese
Level 5

When is the best time to run a transactional log backup job?  Is it better to run a transactional log backup after a full SQL backup job?

1 ACCEPTED SOLUTION

Accepted Solutions

pkh
Moderator
Moderator
   VIP    Certified

It is better to run a transaction log backup after either a full or incremental database backup.  With this backup, you do not need the transaction log to bring the database up to date.

View solution in original post

1 REPLY 1

pkh
Moderator
Moderator
   VIP    Certified

It is better to run a transaction log backup after either a full or incremental database backup.  With this backup, you do not need the transaction log to bring the database up to date.