What are the challenges you face when working across database platforms? Take the survey

Attempting Trans log backups on Simple DBs?

MMarrouMMarrou Posts: 2
edited July 30, 2011 10:52AM in SQL Backup Previous Versions
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.


  • Options
    peteypetey Posts: 2,358 New member
    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
Sign In or Register to comment.