Thanks.

But unfortunately simple recovery won't be possible as the database is mirrored.

I am running the log backups every hour now. I have also managed to shrink the database to 39GB.

Thanks...

It returned over 800 rows :ermm:

So I guess I need to schedule the transactional log backups to run let's say every 3 hours?

It was the latter

Thanks so much! Makes sense 🙂

No, but I'm picking it up in the activity monitor

No rows returned.

I know it's not running anything, but why is it still there though?

I'm not, the Manager of the client is "worried" the the master database has a process running now for a few days :\

Apologies

We are running SQL server 2005 Standard Edition SP3

Ruan