IT Support in Seattle

Enter Your Information Below To

Book a Complimentary Review.

















CyberStreams will never sell or rent your contact information. Your info is secure with us.

Shrinking MS SQL .ldf files from Sharepoint

By:Christine Fettinger

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