Number of user some time face problem related to Transaction log "increasing very soon".
I have also faced same problem with my firm production server. In my case transaction log of Intranet Database was increasing 4 GB every day. Solution and Step which I have done to reduce size of transaction log are mention below:
1. First run SQL query
I have also faced same problem with my firm production server. In my case transaction log of Intranet Database was increasing 4 GB every day. Solution and Step which I have done to reduce size of transaction log are mention below:
1. First run SQL query
S SELECT
log_reuse_wait_desc,name FROM sys.database
2. Run sql command by choosing your Database DBCC OPENTRAN, you will get result
Message:
-if the log_reuse_wait_desc is
replication (for you Database) then remove it
Run query to remove Replication : EXEC
sp_removedbreplication YourDatabaseName
1.
Check recovery model. If it is full then change it to simple
first. Command is
ALTER database <database
name> set recovery simple
Then shrink the log file command is
dbcc shrinkfile (<file
name>,0)
It will shrink your log file at the minimum
level. Now you can change your recovery model from simple to full if required.
Now Size of Database is decrease by using above
steps in my case..
Help
taken from following Blog :
CAUSE
MAY BE: non-distributed LSN in the log
Resolution Help in error like : Can't able to upload document in SharePoint document library .
