Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bazz
Starting Member
26 Posts |
 Posted - 2003-09-12 : 09:40:27
|
| When my log files gets to big my database doesn't work and my web site crashesWhat's the best to clear and manage the log file of my databaseCheers |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-09-12 : 10:07:51
|
| What's the recovery model on your databases? If it is full logging and you don't need point in time recovery then you could set it to simple and your log files will not get as huge. You could also consider (more) regular backups, or BACKUP LOG blah WITH TRUNCATE_ONLY if you don't need backups but want to trim logs. You could schecdule nightly shrinks on your files. Also consider what is causing the log files to get so huge? Is there anything you could do differently?-------Moo. :) |
 |
|
|
|
|
|
Newbie Log files