SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 MS SQL Server log file size being increased
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

imughal
Posting Yak Master

192 Posts

Posted - 07/22/2010 :  02:44:04  Show Profile  Reply with Quote
Hi,

I have installed MS SQL Server on c drive and MS SQL SErver log file size being increased on daily basis.

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG


kindly suggest What is the importance of this log and how can i
shrink and stop this growth.

thanks

Kristen
Test

United Kingdom
22415 Posts

Posted - 07/22/2010 :  02:58:36  Show Profile  Reply with Quote
Sounds like your database is set to FULL Recovery model and you are not doing Transaction log Backups.

if that's the case set up a scheduled task to make the transaction log backups every 15 minutes.
Go to Top of Page

imughal
Posting Yak Master

192 Posts

Posted - 07/22/2010 :  03:42:58  Show Profile  Reply with Quote
Hi,

Guide me about steps to scheduled task

thx
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 07/22/2010 :  04:13:09  Show Profile  Reply with Quote
See the SQL Documentation - "Books Online" available on Microsoft website, or to download
Go to Top of Page

Yeoh Ray Mond
Starting Member

Malaysia
49 Posts

Posted - 07/22/2010 :  05:59:34  Show Profile  Reply with Quote
The directory you are referring to is the default directory where SQL Server logs are stored. When you say that the log file size is increasing daily, are you referring to the file(s) with the ldf extension, or the file(s) that start with 'ERRORLOG...'.

Ray Mond
SQLBackupRestore.com - your quick guide to SQL Server backup and recovery issues
SQL Image Viewer - retrieve, view, convert and export images and binary data from SQL Server, Oracle, DB2, PostgreSQL, SQLite, and Firebird databases.
SQL Data Sets - share and distribute SQL Server, Oracle and PostgreSQL data sets securely and easily
Go to Top of Page

imughal
Posting Yak Master

192 Posts

Posted - 07/22/2010 :  06:10:47  Show Profile  Reply with Quote
i am referring files file(s) that start with 'ERRORLOG...'.
Go to Top of Page

Yeoh Ray Mond
Starting Member

Malaysia
49 Posts

Posted - 07/22/2010 :  07:02:08  Show Profile  Reply with Quote
Those logs store information about important events occurring in the SQL Server engine, and also information on any critical errors that it may encounter. They don't usually grow to a size that becomes unmanageable. How large are your ERRORLOG files?

Ray Mond
SQLBackupRestore.com - your quick guide to SQL Server backup and recovery issues
SQL Image Viewer - retrieve, view, convert and export images and binary data from SQL Server, Oracle, DB2, PostgreSQL, SQLite, and Firebird databases.
SQL Data Sets - share and distribute SQL Server, Oracle and PostgreSQL data sets securely and easily
Go to Top of Page

Yeoh Ray Mond
Starting Member

Malaysia
49 Posts

Posted - 07/22/2010 :  07:06:05  Show Profile  Reply with Quote
and perhaps more importantly, what is being logged in the log files that make them so large?

Ray Mond
SQLBackupRestore.com - your quick guide to SQL Server backup and recovery issues
SQL Image Viewer - retrieve, view, convert and export images and binary data from SQL Server, Oracle, DB2, PostgreSQL, SQLite, and Firebird databases.
SQL Data Sets - share and distribute SQL Server, Oracle and PostgreSQL data sets securely and easily
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 07/22/2010 :  07:43:12  Show Profile  Reply with Quote
Ah, good catch Ray.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000