March 15, 2004 at 12:30 pm
Hi every body,
This error occurs when I´m try to delete some records from one table.
Does any one have some idea about this error?!
What could I do in this case ?!
Thanx in advanced !
March 15, 2004 at 2:14 pm
what error number are you getting? is the database transaction log full or is there something that is preventing it from increasing in size?
HTH
Billy
March 15, 2004 at 2:31 pm
If it's full, then backup transaction with no_log should help. Be sure you then take a full backup as you won't be able to point in time restore.
Check the sQL Server errorlog for some more info on what's occurring.
March 16, 2004 at 5:34 am
Well,
Unfortunatly, the problem is not log's full. The transaction log has 500 MB free.
We try to detach DB, but this error occurs again.
The full error message is:
ERROR 9001 - "The log for database '%.*ls' is not available."
March 16, 2004 at 7:28 am
Did you recently move your .ldf file for the database without detaching it?
Do a search and see if you can find your .ldf for the database. Is it where it's supposed to be?
-SQLBill
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply