Jump to content

Archived

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

Thierry

Database log file is huge

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

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

×

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.