Jump to content


Photo

Database log file is huge


  • Please log in to reply
1 reply to this topic

#1 Thierry

Thierry
  • Members
  • PipPipPip
  • Advanced Member
  • 85 posts
  • LocationNetherlands

Posted 03 January 2006 - 12:52 PM

I am building a user interface PHP website which uses a MSSQL database to store stuff. When I was using Access as my interface, the Access files where only a couple MB, but now the log file has grown to 8Gb! I dont know why, I haven't uploaded 8GB or anything near that at all....
Have you tried....a reset?

#2 Munchen

Munchen
  • Members
  • PipPip
  • Member
  • 12 posts

Posted 05 January 2006 - 03:28 PM

[!--quoteo(post=332723:date=Jan 3 2006, 01:52 PM:name=Thierry)--][div class=\'quotetop\']QUOTE(Thierry @ Jan 3 2006, 01:52 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
I am building a user interface PHP website which uses a MSSQL database to store stuff. When I was using Access as my interface, the Access files where only a couple MB, but now the log file has grown to 8Gb! I dont know why, I haven't uploaded 8GB or anything near that at all....
[/quote]

Well, You must have done something ... Remember, in full recovery model, Your logfile(s) will get filled with all Your INSERT, UPDATE & DELETE statements.
To make Your logfile smaller, You can do some things ...

1: If You dont ever wanna use Your logfile, set the database to Simple Recovery Model.

2: Setup a backup rutine of Your log file, as this will "truncate" Your log.
-Munchen
Denmark




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users