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 |
|
sql2020
Yak Posting Veteran
54 Posts |
 Posted - 2012-07-01 : 23:01:33
|
| Hi I have a Database "xyz" in Simple recovery model"... I got log file full error on this database.If i take full backup for this DB is log will clear?sql2020 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-01 : 23:31:36
|
| take fullbackup and truncate log------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-07-02 : 15:34:01
|
| You cannot truncate the log in simple recovery. Performing a backup does not clear the log in any recovery model. In simple recovery model, the log will be truncated after the next checkpoint or when it reaches approximately 70% full.In this case, the issue is that the transaction is growing the log file until it fills the drive and you then get a file full error. The solution to this is to either get more disk space - or reduce the size of the transaction (e.g. batch the insert/update/delete process that is causing the log file to grow).Jeff |
|
|
|
|
|
|
log full in simple recovery model DB