SQL 2012 Always ON Cluster and Log Truncate

Posted on 2014-08-19
Last Modified: 2014-08-23
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 ?

Question by:Anestis Psomas
    LVL 25

    Expert Comment

    by:Dan McFadden
    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:


    Author Comment

    by:Anestis Psomas
    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
    LVL 25

    Expert Comment

    by:Dan McFadden
    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.
    LVL 75

    Accepted Solution

    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'

    Author Comment

    by:Anestis Psomas
    The problem is in the log_reuse_wait column . Thanks anthony!!

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now