All SharePoint Timer jobs stopped inspite of timer service running.
One the causes which i have found is because of the SQL DB transaction logs getting full.
Best and low cost way of rectifying this is to schedule a sql job to shrink the log file on weekly/fortnightly basis.
Please find below the syntax for the same
SQL:
DBCC SHRINKFILE("MyDatabase_Log", 1)
BACKUP LOG MyDatabase WITH TRUNCATE_ONLY
DBCC SHRINKFILE("MyDatabase_Log", 1)
One the causes which i have found is because of the SQL DB transaction logs getting full.
Best and low cost way of rectifying this is to schedule a sql job to shrink the log file on weekly/fortnightly basis.
Please find below the syntax for the same
SQL:
DBCC SHRINKFILE("MyDatabase_Log", 1)
BACKUP LOG MyDatabase WITH TRUNCATE_ONLY
DBCC SHRINKFILE("MyDatabase_Log", 1)
No comments:
Post a Comment