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
Anestis PsomasSystem and Network AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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 PsomasSystem and Network AdministratorAuthor 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Anestis PsomasSystem and Network AdministratorAuthor Commented:
The problem is in the log_reuse_wait column . Thanks anthony!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.