log_reuse_wait_desc = replication, can't shrink log files.

Posted on 2014-01-19
Last Modified: 2014-01-19
Hello Experts,

My ERP production database went down over the weekend. The cause is because of the drive that holds my DB is out of space.

After investigating, I found that my log files have grown from 600mb a piece to 100 gigs each (qty 2).

I have followed all the correct steps to shrink my database but i cannot.

after some further investigation i found out that the cause is because

'log_reuse_wait_desc = replication,'

WE HAVE NO REPLICATION on this server.

One of the steps i read i should take is to enable a replication publication and then delete it, (

but, the problem is that I cannot create a publication, when i try, i get an error message saying

"Invalid object name: dbo.syspublications"
Question by:FutureDBA-
  • 2
  • 2
LVL 16

Accepted Solution

Surendra Nath earned 500 total points
ID: 39792867
try this

USE [Database_Name]
EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0,@time = 0, @reset = 1
SELECT name,recovery_model_desc,log_reuse_wait_desc FROM SYS.DATABASES

Open in new window

Author Comment

ID: 39792935
My results are
tempdb	        SIMPLE	NOTHING
model	        FULL	        LOG_BACKUP
msdb	        SIMPLE	NOTHING

Open in new window


Author Closing Comment

ID: 39792967
You my friend, have just relieved the most pressure and stress I've had in the last year.

I was going to have hundreds of very unhappy end users in the morning.
LVL 16

Expert Comment

by:Surendra Nath
ID: 39793001
I hope you mean very happy end users (not unhappy end users)

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Stored procedure query with if 27 37
Sql Permission 6 53
Need help debbuging stored procedure 21 35
Getting max record but maybe not use Group BY 2 18
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sending a Secure fax is easy with eFax Corporate ( First, just open a new email message. In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With  eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

864 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

21 Experts available now in Live!

Get 1:1 Help Now