Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

log_reuse_wait_desc = replication, can't shrink log files.

Posted on 2014-01-19
4
Medium Priority
?
3,435 Views
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, (http://www.sqlservercentral.com/Forums/Topic695034-357-1.aspx)

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

"Invalid object name: dbo.syspublications"
0
Comment
Question by:FutureDBA-
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 2000 total points
ID: 39792867
try this

USE [Database_Name]
GO
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


http://subhrosaha.wordpress.com/2011/12/17/sql-server-log_reuse_wait_desc-set-to-replication/
0
 

Author Comment

by:FutureDBA-
ID: 39792935
My results are
master	SIMPLE	ACTIVE_TRANSACTION
tempdb	        SIMPLE	NOTHING
model	        FULL	        LOG_BACKUP
msdb	        SIMPLE	NOTHING
ERMS_CU3	SIMPLE	REPLICATION
ERMS_TST	        SIMPLE	NOTHING
EXPLink	        SIMPLE	NOTHING

Open in new window

0
 

Author Closing Comment

by:FutureDBA-
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.
0
 
LVL 16

Expert Comment

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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

636 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