Follow

arcserve-KB : UDP || SQL | How to confirm if the Transactional LOG's are getting truncated.

Last Update: 2018-04-18 22:41:44 UTC
Description:

How to confirm if SQL is truncating logs or not (This step is after verifying the recovery model, permissions, backup plan log truncation options and other troubleshooting steps)

Solution:
 
Validation Steps:

PART A: Before submitting a backup follow the steps below

  1. Run SQL Management Studio
  2. Run SQL Query: DBCC SQLPERF (LOGSPACE)
  3. Take screenshot of the output screen




PART B: After the backup job is completed follow the below steps

  1. Run SQL Management Studio
  2. Run Query: DBCC SQLPERF (LOGSPACE)
  3. Compare column 'Log Space Used(%)' before and after backup



If you see 'Log Space Used(%)' after backup is less than before backup then SQL is truncated.

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments