select log_reuse_wait_desc from sys.databases where name = ‘AdventureWorks’
If Output is “LOG_BACKUP”
— Execute 2 Times just in case —
BACKUP LOG AdventureWorks TO DISK=’NUL:’
— Now Truncate the Log —
ALTER DATABASE AdventureWorksSET RECOVERY SIMPLE WITH NO_WAIT;
DBCC SHRINKFILE(AdventureWorks_LOG, 100);
ALTER DATABASE AdventureWorks SET RECOVERY FULL WITH NO_WAIT;
In case your mirroring has been suspended and you have tried everything else and nothing works. Your last option is to break the mirroring and restore the mirror database and connect the client application to the mirror site.
Before proceeding with this please note that doing this will require you to rebuild the Data Mirroring again.
At the Principal Site
ALTER DATABASE SET PARTNER OFF
At Mirror Site
RESTORE DATABASE WITH RECOVERY