Shrinking MS SQL .ldf files from Sharepoint
Small Business Server 2003 comes with Sharepoint installed and yet no management software for the SQL portion. Consequently the log files can grow and fill up the system drive. To check for this look in:
C:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data
The sharepoint databases contain sharepoint in the name, making them fairly easy to pick out.
Download and install MS SQL Server Management Studio Express:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
Start the program and in the “Server Name” field specify:
\\.\pipe\mssql$microsoft##ssee\sql\query
Expand “Databases” and choose the database with the same name as your offending .LDF file (such as SharePoint_Config_Unique_Random_string).
Right-Click on the database and select properties. Under Options change the Recovery Model from Full to Simple and hit OK.
Right Click again on database, select “Tasks” –> “Shrink” –> “Database”
Your database should quickly be much smaller.
Selecting Simple recovery carries some risk of data loss; the following MSDN page will list the differences so you can decide if the risk is worth it for your company: http://msdn.microsoft.com/en-us/library/ms189275.aspx
This entry was posted on Monday, January 25th, 2010 at 3:24 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.