October 31, 2011 at 10:17 am
Hello Experts,
Problem: I am getting error from db saying log file full. Each time I need to go and clear some table due to space restrictions. The deleting of .log file is not possible as I do not have file access permission the site deployment.
I wanted to turn off the logging of database.
How can i achieve that?
Thanks in Advance,
Jean Paul http://www.jeanpaulva.net
October 31, 2011 at 10:20 am
jeanpaulva (10/31/2011)
I wanted to turn off the logging of database.How can i achieve that?
.log?
is this an IIS issue?
You dont turn off logging to the SQL Server database. It sounds to me as if you have logging issues on your website
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 10:24 am
I mean the database log.
Each time when we update a record the previous values are stored in the transaction log.
I need to turn off this feature.
October 31, 2011 at 10:52 am
you can't, the transaction log is used to recover the database during a restart!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2011 at 1:44 pm
Maybe start by reading these:
http://www.sqlservercentral.com/articles/Administration/75461/
http://www.sqlservercentral.com/articles/64582/
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
October 31, 2011 at 10:39 pm
Thank You friends.. I got the knowledge.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply