Incremental database backup fails - BACKUP LOG cannot be performed
Posted on 2008-11-04
For the past month or so, incremental backups of two specific SQL databases have failed, with the message from the ODBC SQL Driver stating that "BACKUP LOG cannot be performed because there is no current database backup". All other databases on the SQL server in question are successfully backed up incrementally. I Googled around and noticed this is a frequent message when performing backups in SQL server, but I am unsure how to apply this to BrightStor's SQL agent.
What I believe has triggered this issue is that I created a one-time file-based backup of the two databases from within SQL Management Studio, in order to create a snapshot of the databases for our CRM vendor, whom we maintain a tight relationship with. Ever since I manually created that snapshot, incremental backups on just those two databases has failed. Obviously, full backups are fine.
Further, one day I performed another manual file-based full backup, and then a transaction log backup. That night's incremental backup completed. However, other incrementals from that day forward have continued to fail.
I know the message relates to the transaction log backup chain being broken, and there are ways of reconstructing the chain from the last full backup. But I am unsure how this would relate to BrightStor's SQL Agent.
The SQL Server is MS SQL 2005 Enterprise SP1, backed up by BrightStor 11.5 SP3 with the SQL Agent.
What do I have to do in order to get incremental SQL backups for these two databases going again? Thanks!