It's ok, discussed with the user. We'll create the database, and grant him db_owner on that database only.

Thanks for all your help everyone.

Just run a transaction log backup then a differential backup. There is now 31 GB of space in the log, and the diff. backup was...

PravB4u (12/3/2013)

---

try this

http://akawn.com/blog/2012/01/resolve-log_reuse_wait_desc-is-replication/%5B/quote%5D

Brilliant, thanks. That's changed the log_reuse_wait_desc to LOG_BACKUP.

I'm going to check my backups now.

We haven't done anything to this database. There is a possibility that...

There's nothing under Local Publications or Local Subscriptions

Ok, so that is REPLICATION.

I don't get that... there is nowhere for it to replicate to

If I run

use %databasename%

then the select command, will this give me the correct result?

NOTHING

CHECKPOINT

LOG_BACKUP

NOTHING

LOG_BACKUP

NOTHING

NOTHING

NOTHING

LOG_BACKUP

LOG_BACKUP

NOTHING

CHECKPOINT

NOTHING

NOTHING

NOTHING

NOTHING

CHECKPOINT

REPLICATION

LOG_BACKUP

LOG_BACKUP

LOG_BACKUP

LOG_BACKUP

NOTHING

LOG_BACKUP

NOTHING

NOTHING

LOG_BACKUP

LOG_BACKUP

NOTHING

NOTHING

NOTHING

NOTHING

NOTHING

NOTHING

Nope, no long running transactions, no blocking transactions....

Any other ideas?

Absolutely sure, all other db's are backed up on the same maintenance plan, and all other backup...

Keith Tate (12/2/2013)

---

Have you checked to see how much space is being used inside your tlog file? If it is all 30GB then you have your answer, but the next...