CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.

Knowledge Base

Breadrumbs:
>>Development (Web and Desktop) >> Database >> Microsoft SQL Server Management Studio
SQL Server Log Files are Huge!

Share With Friends ^{(Updated 6-8-2010)}

Article ID:
193
Date Created
Wednesday, January 9, 2013
Last Updated
Wednesday, January 9, 2013
This Article Has been Viewed
1608 times
Short Desc
SQL Server has huge log files, that can grow to large Gb in size. This is simple to stop.
Details
When you create SQL Server database's, by default, they are set to grow large log files, this is easily fixed through the Management Studio.
Recreate Issue
To recreate this issue.

Create a new database, and do not change the [Options] Settings
Resolve Issue
To resolve this issue.

Open [Management Studio]
Right Click on the Database that you need to change the log file size of.
(This may need to be perform to all database's)
Once the Database Properties dialog appears
Click on [Options]
From the [Recovery Model]: Choose [Simple]
Click [OK]
Then Perform the following.

Go to [My Computer]
[Control Panel]
[Administrator Tools]
Then Choose [Services]
Scroll down to [SQL Server (NAME)] <= Right Click and choose [Stop]
Now, browse to the location where you have your SQL Server installed.
Example: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

Now, in this folder, delete ONLY the following files.
All _log.ldf

Once this is completed.
Restart the SQL Server Services.

The log files will now be small, and will no longer be huge.

Always remember, when you create new Database's, you will want to perform this procedure each time, if not, you will experience large log files.

All Topics