I'm getting the error like this "The transaction log for database 'xxx' is full.
Example.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCofDCCQSZnIYftokQry8CzlywB6NKItKPaRChsffEJQva7UM6Uv0K0ThfHkxjDp9harh24I28Z5Zzf3FBee5_FzTLLZ8QqsCL4uZGqnZx3m3eJnUJsCiqhSsMFEAZ9yMJkMNSV8A9dTS0/s1600/Tran+log+full.png)
Solution:
There are several potential causes for this, for example:
1. The SQL server's hard drive is full
2. The relevant database (for example 'XXX') has been configured to have a maximum log file size.
This maximum limit has now been reached.
To Increase Log file size
Example:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJnhUQo6WZRWWFIiN9i7mSc30GQ1mmJY1lBLcTQzmR4rlluWI5iVg8Mcs4pkHq3-F6_lFYWV3gf5F3jiKG-gEa8lV_CsEjnLpqIbZbh-pQgG_86aNiNPryxCKkf49ikt5FwEYlJbNcq0VD/s1600/Step1.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgtQJpTOeBxhYxCt7Tq-XtAm81u2HCPMYjOOopwDnPS26CBItePBUqEGxhJaedppbL502xF-SLDmU5ifIlJhvNMjwTgQWuTzDdB7nySxsdRxUhVTkWxNQLhi-74yvlLIbcVyJONJ_hiHon/s1600/Solu.png)
** Problem resolved **
Example.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCofDCCQSZnIYftokQry8CzlywB6NKItKPaRChsffEJQva7UM6Uv0K0ThfHkxjDp9harh24I28Z5Zzf3FBee5_FzTLLZ8QqsCL4uZGqnZx3m3eJnUJsCiqhSsMFEAZ9yMJkMNSV8A9dTS0/s1600/Tran+log+full.png)
Solution:
There are several potential causes for this, for example:
1. The SQL server's hard drive is full
2. The relevant database (for example 'XXX') has been configured to have a maximum log file size.
This maximum limit has now been reached.
To Increase Log file size
Example:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJnhUQo6WZRWWFIiN9i7mSc30GQ1mmJY1lBLcTQzmR4rlluWI5iVg8Mcs4pkHq3-F6_lFYWV3gf5F3jiKG-gEa8lV_CsEjnLpqIbZbh-pQgG_86aNiNPryxCKkf49ikt5FwEYlJbNcq0VD/s1600/Step1.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgtQJpTOeBxhYxCt7Tq-XtAm81u2HCPMYjOOopwDnPS26CBItePBUqEGxhJaedppbL502xF-SLDmU5ifIlJhvNMjwTgQWuTzDdB7nySxsdRxUhVTkWxNQLhi-74yvlLIbcVyJONJ_hiHon/s1600/Solu.png)
** Problem resolved **
0 Comments