I am stuck.
I've just taken over maintenance on a SQL Server...that has not been backed up in quite a while...The log file has grown to over 1.61TB...Yes, 1.61TB.
It has swallowed all available disk space. I've tried to backup (can't because of the log file size), I've tried detaching (can't because the logfile is full), I've tried shrinking the DB and log file (can't...get various errors.) I'm in a really tough spot for a couple of reasons...
This is no longer a program that is 'used' but folks still access it to get data.
This has taken a 2TB drive down to 9.94MB.
Help.
EDIT: Additionally, I can not change the recovery mode to "FULL" to do a proper backup...It just sits and spins...I'm going to give it a couple of hours and check in on it.
What a pain.