Database is not accessible as transaction log file growing to full On one of our current prod servers, we have one of the data drives going out of space.[Somehow we have created 2 GB space for now]

Now we are planning to move one of the database in different drive which is almost 20 GB. But this database is not accessible state. I was thinking of backup/restore way to move, but it wont as it shows in unavailable state.

When I checked the SQL logs, it says transactional log of this database got full. So I checked its state using log_reuse_wait_desc which says "ACTIVE TRANSACTION".

How can I get the database available and ready for move so that I can move via backup/restore?

Additional Info: Database status shows "SUSPECT"
Please suggest.
First things first, if you need to kill the active user(s) immediately and make sure no more connections are made, you'll want to put the DB in single user mode.

ALTER DATABASE MyDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE


Second you'll need to address the SUSPECT mode and hope it's an easy to fix file access issue.  Try these suggestions to fix your SUSPECT mode

Once that is fixed, do what you need to do with the database - CheckDB, backup, etc.  By keeping it in single user mode other users, including applications and any other user but you, will not be able to access the database.

To put it back in multi user mode use 

ALTER DATABASE MyDatabase SET MULTI_USER


EDIT - I should say this does not resolve why you have an ever growing transaction log.  If it is of concern, you should try to resolve that prior to killing an active transaction with sp_whoisactive, monitoring tools, etc.  But don't let the log fill the drive or it will kill the transaction anyway and roll it back.