Tuesday, 14 October 2008

Is the server hosting your SharePoint database running out of space?

If so have you checked your SharePoint log files? While installing SharePoint configuration and content databases are created in SQL Server. By default, these databases are created in Full Recovery Mode – better than none at all. So for each SharePoint database created, a data file and a full log file is also created!

But don’t forget that if backups are run without truncating the log files, your log files will quickly increase.

To find out the size of a database log file run the following Database Console Command (DBCC for short):
  1. In Microsoft SQL Server Management Studio (SQL Server 2005 or 2008), open New Query
  2. In New Query, type:
This will give the log size for databases.

For more details on DBCC SQLPERF (LOGSPACE) see http://msdn.microsoft.com/en-us/library/ms189768.aspx

No comments: