May 6, 2004 at 6:25 am
Hi,
I am running several databases on a server cluster and have now been locked-out by the enterprise manager. I think the root cause of this problem was one of the databases' transaction logs filling up the disk partition upon which it was set up.
Since this happened I have been unable to access any of the databases on the cluster and am stuck with a system which I cannot repair or administer.
Can anyone help with this at all, as it's super urgent?
Thanks in advance,
Jay.
May 7, 2004 at 3:17 am
Just an idea you may want to try.
Access a different server and set up a link to the server causing you problems. You can then run a command to free up some space. e.g. back up log with truncate only.
May 11, 2004 at 9:11 am
Thanks Johnathan.
Just to let you know that the problem I encoutered was as a result of the database going into automatic recovery mode due to a BizTalk purge script which caused locks that left the database in an inconsistent state.
It turned out the only thing to do was wait until the database had fully recovered - this can take a long time if the database is large - when this is complete you should be able to once again access your data.
Thanks,
Jay.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply