--// During index maintenance
The statement has been terminated.
Msg 9002, Level 17, State 5, Line 2
The transaction log for database 'VeryBIGDB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
log_reuse_wait_desc: database_mirroring
Quick what to do what to do.....
ALTER DATBASE [VeryBIGDB] SET PARTNER OFF
BACKUP LOG [VeryBIGDB] TO DISK='Wherever.hbc'
Lucky for me I have a job already configured and part of log shipping strategy, so I just ran the job.
SHRINK LOG Files
Deep breathes WUSAaaaaaa.
But now....
:-(
Msg 1404, Level 16, State 5, Line 1
The command failed because the database mirror is busy. Reissue the command later.
C'mon, give me a frickenfarackenchikenmonkey break!!!!
Google said, sorry just restart the mirror from scratch.
MAN-UP.
Gotta go, running dark now.
UPDATE:1:26AM
Miraculously the mirrored DB stopped complaining about being busy.
Shot of adrenealine when i saw that.... DING DING DING... ROUND 3, FIGHT
Dug through the Log Shipping backups for said DB, with cmdline nugget:
C:\>dir /b L:\BOBSQLBACKUPS\TRN\VeryBIGDB_20110327_2*
C:\>dir /b L:\BOBSQLBACKUPS\TRN\VeryBIGDB_20110328_*
Add a dash of Excel, cut-n-paste, and a nifty formula:
="RESTORE LOG [VeryBIGDB] FROM DISK = 'L:\BOBSQLBACKUPS\TRN\" & A1 & "' WITH NORECOVERY,STATS=10;"
=
RESTORE LOG [VeryBIGDB] FROM DISK = 'L:\BOBSQLBACKUPS\TRN\VeryBIGDB_20110327_2000_LOG.hbc' WITH NORECOVERY,STATS=10;
RESTORE LOG [VeryBIGDB] FROM DISK = 'L:\BOBSQLBACKUPS\TRN\VeryBIGDB_20110327_2015_LOG.hbc' WITH NORECOVERY,STATS=10;
RESTORE LOG [VeryBIGDB] FROM DISK = 'L:\BOBSQLBACKUPS\TRN\VeryBIGDB_20110327_2030_LOG.hbc' WITH NORECOVERY,STATS=10;
...........
RESTORE LOG [VeryBIGDB] FROM DISK = 'L:\BOBSQLBACKUPS\TRN\VeryBIGDB_20110328_0115_LOG.hbc' WITH NORECOVERY,STATS=10;
......
Ran it with error cause not all were needed, too early to apply to the database....
BUT then:
10 percent processed.
20 percent processed.
30 percent processed.
......
....
;-(( Sniff sniff, tears of joy...
Resync mirror looking very promising... knock on wood...
RESTORE LOG 97.05813