Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2010-07-22 : 02:44:04
|
| 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\LOGkindly suggest What is the importance of this log and how can i shrink and stop this growth.thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-22 : 02:58:36
|
| 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. |
 |
|
|
imughal
Posting Yak Master
192 Posts |
Posted - 2010-07-22 : 03:42:58
|
| Hi,Guide me about steps to scheduled taskthx |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-22 : 04:13:09
|
| See the SQL Documentation - "Books Online" available on Microsoft website, or to download |
|
|
|
Yeoh Ray Mond
Starting Member
49 Posts |
Posted - 2010-07-22 : 05:59:34
|
| 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 MondSQLBackupRestore.com - your quick guide to SQL Server backup and recovery issuesSQL 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 |
|
|
|
imughal
Posting Yak Master
192 Posts |
Posted - 2010-07-22 : 06:10:47
|
| i am referring files file(s) that start with 'ERRORLOG...'. |
|
|
|
Yeoh Ray Mond
Starting Member
49 Posts |
Posted - 2010-07-22 : 07:02:08
|
| 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 MondSQLBackupRestore.com - your quick guide to SQL Server backup and recovery issuesSQL 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 |
|
|
|
Yeoh Ray Mond
Starting Member
49 Posts |
Posted - 2010-07-22 : 07:06:05
|
| and perhaps more importantly, what is being logged in the log files that make them so large?Ray MondSQLBackupRestore.com - your quick guide to SQL Server backup and recovery issuesSQL 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 |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-22 : 07:43:12
|
| Ah, good catch Ray. |
|
|
|
|
|
|
|
|
MS SQL Server log file size being increased