February 18, 2009 at 10:11 pm
In my database logfiles is incresing very fast.
I am using Shink Command for this.
but some time it Crash the system.
Problem is we had some Activity done
in our application like
by opening the form (in window applicaiton)
we put entry on the table and after closing
the form we delete the entry in the table.
Is there any other way that i can put the entry
in the data base without using hardcode table ?
one thing that table is use by another user
on another system that he get the message that
this form will open.
our system i use by more than 30 user 24 hour so
log files is incresing very much,
any solution for that then please give me.
February 18, 2009 at 10:49 pm
I have to admit that I didn’t understand the part about your application, but there are few remarks about your log file. First of all stop shrinking it. If you shrink it and it grows to its size again, then let it stay at the size that he got. You will gain nothing at all by shrinking it all the time. The second thing is to read about recovery models (you can find details in BOL or just do a search in Google about recovery model SQL server). After you’ll understand what Recovery model is, you’ll have to decide what recovery model to use. If you’ll use simple, then most chances that your log will not grow very much. If you’ll use another recovery model, then most chances that you’ll have to increase the number of log backups.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 18, 2009 at 11:04 pm
you can also check if some bulk upload is happening.... if yes, you can switch the recovery to bulk-logged for the period of bulk upload to prevent the log file from growing heavily.
as suggested, the first option to look is the recovery model and log backup frequency (if its full mode).. increase the frequency of log backups....
February 19, 2009 at 1:35 am
Please read through this - Managing Transaction Logs[/url]
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 2:10 am
that is nice article.thnks for it.
but one thing is i dotn want recover from
log.
i need solution for how i can not inert in to
the log files
is there any way that i can not insert entry in the log files?
February 19, 2009 at 2:21 am
keep recovery model of the database Simple. this will keep on removing inactive log entries at regular frequent intervals.
February 19, 2009 at 5:52 am
kuldip.bhatt (2/19/2009)
is there any way that i can not insert entry in the log files?
No. Changes are always logged and there's no way to stop logging. Logs are used to ensure that the DB is transactionally consistent all the time.
If you don't need point-in-time recovery, switch to simple recovery model.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply