Home > MOSS, SharePoint, wss > Shrink SharePoint configuration database log file

Shrink SharePoint configuration database log file


USE DatabaseName
GO
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 10)

Where 10 is the size to which the log file will be shrrinked..in this case it is 10 MB

You can also do it from the SQL Management Studio

Right Click on Database –> Tasks –>Shrink –>Files—>Select “Log” option from the dropdown and then select the shrink size

Advertisements
Categories: MOSS, SharePoint, wss
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: