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.