Table of Contents

log_reuse_wait_desc errors after restore

What may happen is that the database sets itself to replication mode, and does not allow the shrinking of the transaction log while continuing to grow indefinitely.

To verify if this is the case run a new query on the DB:

USE master;
GO
SELECT name, log_reuse_wait_desc, * FROM sys.databases
WHERE name = 'MYDB';

You should see:

 

 

USE master
EXEC sp_removedbreplication
	@dbname = 'MYDB'
GO

  1. Proceed to backup MYDB

  2. Shrink MYDB

  3. Backup the MYDB transaction log

  4. Shrink the MYDB transaction log

Insert Next Topic

  • No labels