cancel
Showing results for 
Search instead for 
Did you mean: 

Transaction log is growing in Simple mode

Former Member
0 Kudos

Hi All,

We have installed SAP EHP6 system on MS SQL 2008 R2, Since it was development system we have kept in simple mode.

But still we find the Transaction log is growing daily and cannot  truncate the log.

I found the  below reuse wait reason as Replication.

Recovery model          SIMPLE

Reuse wait reason       REPLICATION

Do we have DB setting as above as default  when we install MS SQL or any DB consultant has changed any parameter.

And also how can we remove Replication for Transaction Log.

Regards,

Kiran

Accepted Solutions (0)

Answers (5)

Answers (5)

Sriram2009
Active Contributor
0 Kudos

Hi  Jacinto

I thing your Database is enable for log shipping, may be because of that its showing the "REPLICATION"

Regards

Sriram

chandrababu_katta
Participant
0 Kudos

thanks Sriram,

In my post 2 images are from 2 diff systems, just to show u my Q's and how to take LogBackup nd how to make it as Nothing. Could u please eloberate..

Sriram2009
Active Contributor
0 Kudos

Kindly refer the Microsoft link

Back Up a Transaction Log (SQL Server)

Regards

Ram

chandrababu_katta
Participant
0 Kudos

how to change Reuse_wait_reason to Nothing from LOG_BACKUP as shown in figure(below)

Sriram2009
Active Contributor
0 Kudos

Hi Katta

when you are performing the Log backup (Truncate or No Truncate backup) it will change the status to " Log Backup" after completes then it will change the status to " Nothing" .

Regards

Sriram

former_member184473
Active Contributor
0 Kudos

Good to see we have more and more people helping at the SQL Server SCN space.

Thanks and !

clas_hortien
Active Contributor
0 Kudos

Hi,

this link might help you to remove the replication.

Regards

  Clas

former_member188883
Active Contributor
0 Kudos

Hi Jacinto,

As per Note 555223 - FAQ: Microsoft SQL Server

Q1: Is it possible to disable the transaction log completely ?

A1: No. As the transaction log contains the 'redo' and 'undo' information for the transactions, it can't be disabled. This information is needed to ensure the logical consistency in a case of a rollback of transactions. Even when the database is in "simple" or "bulk-logged" mode, the SQL Server logs all changes in a DB into the transaction log.

Additional information simple mode can be found int  

Note 421644 - SQL error 9002: The transaction log is full

Section : The Simple Recovery Model

For details on reuse wait reason/ Replication refer the link below

   http://msdn.microsoft.com/en-sg/library/ms345414(v=sql.105).aspx

Hope this helps.

Regards,

Deepak Kori