|
|
|
|
||||||
![]() |
|
|
LinkBack | Outils de la discussion |
|
|
#1 |
|
Messages: n/a
Hébergeur: |
im having an issue with sql server 2005 express on a test box. im
trying to use an app to add records to some tables in a database, 1 record at a time. but in doing so i get this "The transaction log for database 'ScanOrder2' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases" with every insert of a record. this process was working fine 2 days ago and i cant find anything thats been changed. - i deleted the database and tried restoring it from a backup that is known to work, but still has the issue - the recovery model is set to simple. every night a batch script is run to truncate the log file in case there is a transaction that uses a lot of records - i can insert and delete records manually with no problems (ie going in through SSMSE and highlighting a row and deleting it or adding random data) but i still cant add it through the app - the log file is set to autogrow unrestricted at 10 megs at a time. - i even tried setting the log file to 500 megs starting size, and still couldnt even insert 1 record - when i check the log_reuse_wait_desc, it says NOTHING, when not running and while running. is there any other setting i could be missing that might attribute to this? |
|
![]() |
| Outils de la discussion | |
|
|