| Chris Wood 2006-12-06, 7:12 pm |
| Hi,
We like to make our databases have the Full recovery model and then take
hourly log backups and take others, by setting an alert, if the log gets
over a certain percentage full. This works fine in SQL2000 and still works
if the application database is set to the Bulk-logged recovery model.
Now in SQL2005 we cannot create a maintenance plan and job for the log
backup if the recovery model is Bulk-logged. So we set the recovery model to
Full and create the plan and job. If the database gets set back to
Bulk-logged the log backup job reports as having run successfully but does
not actually create a log backup (.trn) file. If the log fills and fires the
alert to run the log backup all appears fine except the alert keeps on
firing. Using the GUI Summary/Reports the log appears to be offloaded but
with no actual log backup file created it is obviously not getting cleaned
up.
We are using SP1 build 2047. Is this a known problem?
Thanks
Chris
|