on 04-18-2013 11:00 PM
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
Hi Jacinto
I thing your Database is enable for log shipping, may be because of that its showing the "REPLICATION"
Regards
Sriram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.