Urgent: Log backups failed and cannot shrink

[Luvsql]

Our log backup has been running for 5 hours and the log has since grown to 36Gb. The database was changed to simple mode, but cannot shrink the log (error could not adjust the space allocation for database). The drive does have 35Gb free. I also cannot change back to full recovery as it says it needs to be backed up.

We do not have sufficient total space to backup the database and the log (at the size that it is), without first shrinking the log. Any ideas?

 

[mrdenny]

If the database is in simple recovery then you can't backup the log. It will truncate automatically as soon as all open transactions are commited and checkpointed. You can then shrink the physical file.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com