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 |
|
Murali_beit
Starting Member
1 Post |
 Posted - 2005-12-13 : 10:34:43
|
| Please help me on this problem.I have database of nearly 9 GB and i am not able to any transaction in the database as well as through application also. While taking the backup, the sql server 2000 enterprise manager shows the following as a error:" The log file for database <databasename> is full. Backup the transaction log for the database to free up some log space. Backup Database is terminating abnormally.Could not write a checkpoint record in database id (No.) because the log is out of space."The same error is occuring while doing the operation like, shrinking the database, shrinking the datafile, shrinking the transaction file.I will be very helpfull, if any one can re-solve this issue.Thanks and Regards,Murali S |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-13 : 10:39:49
|
| Is the disk full?If so can you delete some "junk" files?If not is the LOG file limited to a fixed size - and if so can you extend it in Enterprise manager?Kristen |
 |
|
|
bakerjon
Posting Yak Master
145 Posts |
|
|
gkrishn
Starting Member
16 Posts |
Posted - 2005-12-15 : 09:52:31
|
| IF you have FULL recovery model, just backup log .This will trucate the inactive part.If that does not work, just backup log TRUNCATE_ONLY . |
|
|
|
|
|
|
Unable to take backup and transaction log is full