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.... 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. 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
Archived
This topic is now archived and is closed to further replies.