[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 880
  • Last Modified:

SQL 2012 Always ON Cluster and Log Truncate

Hello Experts ,

I have an SQL Always on Cluster with 1 DAG to hold my SCVMM Database.  The database is about 400MB in size. Logs are about 450 GB !! I create in DPM 2012 R2 a backup schedule with syncs every 1 hour but the Logs are not truncating. Any ideas ?

Thanks
0
Anestis Psomas
Asked:
Anestis Psomas
  • 2
  • 2
1 Solution
 
Dan McFaddenSystems EngineerCommented:
What is the recovery model on the database?  It should be set to "full".  Also, do you have enough space on the volume where DPM is storing the backups  You would need around 451GB (450GB logs + 0.4GB database) free... I would have at least 15-20% more free space as a buffer.

Some links:

http://technet.microsoft.com/en-us/library/hh780998.aspx

http://technet.microsoft.com/en-us/library/hh757977.aspx

http://jeffwouters.nl/index.php/2012/03/dpmsql-transaction-logs-do-not-truncate/

Dan
0
 
Anestis PsomasAuthor Commented:
Hello ,

The recovery model is Full . This is a prerequisite for this database from SCVMM guide. I also have enough space in my DPM storage pool. I have also read the above links you send me but unfortunately no solution... Maybe something happening with DPM
0
 
Dan McFaddenSystems EngineerCommented:
What is being logged in the DPM Alerts Event Log?  In Computer Management > Event Viewer > Applications and Services Logs > DPM Alerts.  Filter the current log showing only errors & warnings.
0
 
Anthony PerkinsCommented:
Have you looked at the value in the log_reuse_wait column for this database?  As in:
SELECT log_reuse_wait
FROM sys.databases
WHERE name = 'yourdatabasenamegoeshere'
0
 
Anestis PsomasAuthor Commented:
The problem is in the log_reuse_wait column . Thanks anthony!!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now