April 7, 2009 at 10:18 am
Hi,
I have a database on a sql server 2005. A maintenance plan performs a
full backup every night at 10:30 PM, while a maintenance plan performs a backup of the transaction log is done every 1 hour (Schedule to run from 12 AM to 10:30 PM). The LOG backup run frine from 12AM to 7AM. The LOG backup starts to fail from 8AM to 11AM everyday. The LOG backup run fine again from 12PM to 10PM. the error is "BACKUP LOG cannot be performed because there is no current database backup".
the database is in full recovery mode. I just don't quite understand why this is happening !!
Thanks in advance.
April 7, 2009 at 10:33 am
Are you doing something like dropping and recreating the database for some reason? The first time a database is created, you can't perform a TLog backup until you have performed a Full backup. It sounds like you have another process that is interferring with the normal backup routine.
April 7, 2009 at 11:22 am
Sometime between 7am and 8am there's a job running that either switches the DB to simple recovery and back to full or executes a BACKUP LOG ... WITH TRUNCATE ONLY.
My bet is on the latter statement.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply