We are running sql 2008 on server 2003 enterprise.
The db has gone into recovery due to the servers going down unexpectedly, the disk where the log writes to is full (1TB) and (232KB left) due to two log files of circa 500gb each (I know far to big). Consequently the db cannot recover itself as
it can't write logs. We are aware we need to shrink the log and planned to but the server when down before we had chance (electricity company cut through a cable) but cannot do this while in recovery. We cannot move or delete any ldf
files from the drive as it says 'they are in use by another program' aka sql trying to recover. And we have not got room to add more space to the disk it, so it would appear we are in catch 22.
Does anyone have any suggestions as to how we could resolve this issue?
View Complete Post