<div>
That was perfect! &nbsp;Thank you!<br />
<br />
The space went from 14 gig to 1 meg. &nbsp;<br />
<br />
Much appreciated.<br />
<br />
--Ben
</div>


That was perfect!  Thank you!

The space went from 14 gig to 1 meg.  

Much appreciated.

--Ben

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a SQL 2008 DB that has a log file that continued to grow. &nbsp;Tried shrinking it, but that did very little. &nbsp;I then noticed the log_reuse_wait_desc for this DB is set to REPLICATION. &nbsp;It has no replications associated with it. &nbsp;I then noticed the SQL Agent service wasn't running. &nbsp;I started that and it came up fine.<br />
<br />
How can I remove the DB from replication status? &nbsp;As of right now the dbcc loginfo command returns over 5800 rows. &nbsp;Oops.<br />
<br />
Thanks!<br />
<br />
--Ben
</div>
</div>


Hi,

I have a SQL 2008 DB that has a log file that continued to grow.  Tried shrinking it, but that did very little.  I then noticed the log_reuse_wait_desc for this DB is set to REPLICATION.  It has no replications associated with it.  I then noticed the SQL Agent service wasn't running.  I started that and it came up fine.

How can I remove the DB from replication status?  As of right now the dbcc loginfo command returns over 5800 rows.  Oops.

Thanks!

--Ben

Taking a SQL DB out of replication status

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.