Our backup software is working but in the event log I am getting below error at 6am every morning on the dot. It appears 5 times within 60 seconds then I dont see it till 6am the next day.
Running SQL 2005 Express (microsoft). Had a look around the Express Management Studio but cant find any obvious log settings.
Please can someone advize?
Event Type: Error
Event Source: MSSQL$SQLEXPRESS
Event Category: (6)
Event ID: 8309
BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model should be used to automatically truncate the transaction log.