moncomp
asked on
SBS 2008 SharePoint_Config_log.LDF large - how to shrink?
Hey Guys
I am running out of space on my C:\ drive on my SBS 2008 server.
I ran a hard drive search and found that a large chunk of my usage is the "SharePoint_Config_log.LDF " file. It's currently at about 15GB.
In the “SQL Server Management Studio express” I backed up the database and ran a shrink on it. But that made no difference.
I was thinking of detaching the database and deleting the "SharePoint_Config_log.LDF ".
Then setting the maximum growth MB to 1024.
Do you guys think that is a safe thing to do?
I've never performed that task on an SQL database before.
What do you guys think?
Kind Regards
Aaron
I am running out of space on my C:\ drive on my SBS 2008 server.
I ran a hard drive search and found that a large chunk of my usage is the "SharePoint_Config_log.LDF
In the “SQL Server Management Studio express” I backed up the database and ran a shrink on it. But that made no difference.
I was thinking of detaching the database and deleting the "SharePoint_Config_log.LDF
Then setting the maximum growth MB to 1024.
Do you guys think that is a safe thing to do?
I've never performed that task on an SQL database before.
What do you guys think?
Kind Regards
Aaron
Check links below, should help you shrink your log file.
http://www.sharepointboris.net/2008/10/sharepoint-config-database-log-file-too-big-reduce-it/
http://www.inetnj.com/?page_id=305
http://www.sharepointboris.net/2008/10/sharepoint-config-database-log-file-too-big-reduce-it/
http://www.inetnj.com/?page_id=305
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hey Alan
That did the trick :) Now have plenty of space available on the C:\ drive.
Much appreciation for the other options too. They all pretty much lead to the same solution.
That did the trick :) Now have plenty of space available on the C:\ drive.
Much appreciation for the other options too. They all pretty much lead to the same solution.
Here's what I use..
Run this a few times to shrink ldf. Just change the WSS_config to your database
BACKUP LOG [WSS_Config] TO DISK = N'E:\Backup\Backup.bak' WITH NOFORMAT, NOINIT, NAME = N'$Database-Transaction Log Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
DBCC SHRINKFILE (WSS_Config , 0, TRUNCATEONLY)
DBCC SHRINKFILE (WSS_Config , 0, TRUNCATEONLY)
DBCC SHRINKDATABASE(WSS_Config)
DBCC SHRINKFILE (WSS_Config , 42)
Run this a few times to shrink ldf. Just change the WSS_config to your database
BACKUP LOG [WSS_Config] TO DISK = N'E:\Backup\Backup.bak' WITH NOFORMAT, NOINIT, NAME = N'$Database-Transaction Log Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
DBCC SHRINKFILE (WSS_Config , 0, TRUNCATEONLY)
DBCC SHRINKFILE (WSS_Config , 0, TRUNCATEONLY)
DBCC SHRINKDATABASE(WSS_Config)
DBCC SHRINKFILE (WSS_Config , 42)
http://support.microsoft.com/kb/2000544
However do backup you SharePoint database before making changes.