|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
|
Administration | |
|
Backup/Restore | |
|
Connectivity | |
|
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
|
Transfer/move | |
|
Trouble | |
 |
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 I am getting an error 1105 - what can I do? Answer: The error 1105 means that transaction log is full. There are to ways to resolve the error 1105: Because the transaction log cannot grow automatically in SQL Server 6.5, you should increase the size of the transaction log manually by using the ALTER DATABASE statement. To truncate transaction log, you can set the Truncate Log On Checkpoint database option, or run the DUMP TRANSACTION command with NO_LOG parameter. See "Causes of the Transaction Log Filling Up" in SQL Server Books Online. |