Filegroup preventing log file from backup

We have a intimidating problem with a production database.
The database have db file situated on primary drive and log file on a secondary one.
The primary drive contains two file group - one for primary DB file and one small FILESTREAM typed group for memory based objects.
The secondary drive contains db log file.
Since some moment the first drive run out of physical space as a result of autogrowth process. The issue is log backup also stopped working at the moment because of the error:

The operating system returned the error '112 (There is not enough space on the disk.)' while attempting 'FsLogMgr::LogInternal:CreateFile'...
At this point transaction log backup is cancelled due to the error. The file group causing the error is the small and currently unused filestream group. It could be dropped easily, but when attempting to remove the filegroup I have different error:

Drop failed for FileGroup [...]
The container can not be dropped because changes exist that require a log backup.  Take a log backup and then retry the ALTER DATABASE operation. (.Net SqlClient Data Provider)


So the issue has circular nature. I cannot do log backup without dropping the filegroup. But I also cannot drop / take offline the filegroup because the operation requires log backup. So the log is growing uncontrollably and the system is heading towards complete failure.

Thanks
hoffman_aAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott PletcherSenior DBACommented:
For now, I'd add another file to the data filegroup to give it sufficient space to begin working again.  Naturally the new space can, and will be, on a different drive.

If you want to, later you can remove the extra file from the data filegroup.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.