SQL 2012 Always ON and Logs Truncade

Posted on 2014-07-17
Last Modified: 2014-08-12
Hello ,

I have an Always ON SQL 2012 Cluster and i want to ask a few thigs about log truncation .

First of all my logs are getting huge. Database is about 300 MB and logs are about 150 GB .

So i install DPM 2012 R2 and im now taking backup the database. After each backup synchronization i was waiting for log truncating but this never happen . Am i doing something wrong ?

Question by:Anestis Psomas
    1 Comment
    LVL 15

    Accepted Solution

    The log files do not automatically shrink, but since you are taking backups they should stop growing.  In order to reduce the size of the log files you will need to run a dbcc shrinkfile command.  This can have consequences so you should read up on how to use the command and whether you should use it in your situation.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Every now and then, Microsoft does something that totally impresses me. It doesn't happen often, but in this case I must say I am thoroughly impressed with Windows Server Backup. One of the long time issues with Windows Backup has been the ability t…
    This article will review the basic installation and configuration for Windows Software Update Services (WSUS) in a Windows 2012 R2 environment.  WSUS is a Microsoft tool that allows administrators to manage and control updates to be approved and ins…
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
    This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

    759 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

    12 Experts available now in Live!

    Get 1:1 Help Now