Jump to content

Database log file is huge


Thierry

Recommended Posts

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....

Link to comment
Share on other sites

[!--quoteo(post=332723:date=Jan 3 2006, 01:52 PM:name=Thierry)--][div class=\'quotetop\']QUOTE(Thierry @ Jan 3 2006, 01:52 PM) 332723[/snapback][/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....

 

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.