VitalNetworkSolutions
asked on
SQL2012 - Sharepoint Config Log File Size
Hi,
I have a client that is running a SharePoint database on a server2008r2. Sql is 2012.
The Sharepoint_Config transaction log file ldf is huge (120gb). The mdf file is only 200mb.
I have been researching the shrink file command, or shrink file via the SQL Server management Studio.
I have ran a 'DBCC SQLPERF(logspace)' and the Log file space used is only 2.7 % on this database.
Can anyone advise me this is safe to do? and is there anything I need to do before running shrinkfile on the ldf file? except taking a full backup of the database.
Thanks, Colin
I have a client that is running a SharePoint database on a server2008r2. Sql is 2012.
The Sharepoint_Config transaction log file ldf is huge (120gb). The mdf file is only 200mb.
I have been researching the shrink file command, or shrink file via the SQL Server management Studio.
I have ran a 'DBCC SQLPERF(logspace)' and the Log file space used is only 2.7 % on this database.
Can anyone advise me this is safe to do? and is there anything I need to do before running shrinkfile on the ldf file? except taking a full backup of the database.
Thanks, Colin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1. Start doing frequent Transaction Log backups or if you are unable to do that then
2. Change the Recovery Model from Full to Simple and lose the ability to do point-in-time restores.
Only do a DBCC SHRINKFILE as a last resort as it is detrimental to the health of your Transaction Log and therefore your database.