Attempting Trans log backups on Simple DBs?

Forum for users of Redgate's SQL Backup tool

Attempting Trans log backups on Simple DBs?

Postby MMarrou » Mon Jul 11, 2011 9:38 pm

We're currently using SQL Backup on some of our servers. I've noticed that it appears at random to decide to try to do a trans log backup on databases marked as simple. It can run 40 times in a day, and just once out of those 40 times it'll try to do a trans log backup on one of the system dbs which are in Simple recovery mode.
I know this is a very old version, but does anyone know why this happens?
I don't really want to go around and change everything to full just to stop it from sending me alarms.

Thanks in advance.
Posts: 1
Joined: Mon Jul 11, 2011 9:25 pm

Postby petey » Sat Jul 30, 2011 2:52 pm

IIRC, it was a strange situation where SQL Server returned the recovery model of the database as full/bulk-logged, when in actual fact, the recovery model was simple. when SQL Backup made 2 queries to retrieve the databases' recovery model. This was subsequently fixed in later versions, where only 1 query was made, where the results are usually correct.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
Posts: 2358
Joined: Sun Apr 24, 2005 11:34 am

Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 2 guests