Solved

SQL2012 - Sharepoint Config Log File Size

Posted on 2014-10-09
2
404 Views
Last Modified: 2014-10-21
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
0
Comment
Question by:VitalNetworkSolutions
2 Comments
 
LVL 31

Accepted Solution

by:
Jamie McAllister MVP earned 500 total points
ID: 40370815
It's safe to shrink it. This Log file bloat is quite common.

There are the below methods, or DBCC Shrinkfile...

http://www.inetnj.com/?page_id=305

http://shareyourpoint.wordpress.com/2013/03/22/how-to-manage-large-sharepoint-configuration-database-logfile/
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 40372044
If you have not run any Transaction Log backups, you will not be able to shrink the Transaction Log.  What I suggest:
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.
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question