Thierry Posted January 3, 2006 Share Posted January 3, 2006 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 Link to comment https://forums.phpfreaks.com/topic/3138-database-log-file-is-huge/ Share on other sites More sharing options...
Munchen Posted January 5, 2006 Share Posted January 5, 2006 [!--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. Quote Link to comment https://forums.phpfreaks.com/topic/3138-database-log-file-is-huge/#findComment-10623 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.