April 30, 2008 at 6:51 am
Hi,
We are facing one issue with log backups ,it is failing continuously in one of the instance,and we found that it is because of one of the DB
Is there any method to overcome this issue,we need the DB with the instance
Is there any one helpme
April 30, 2008 at 7:37 am
What does it say in the error log? What recovery mode does this database have (if simple, you cannot backup logs)? What does "and we found that it is because of one of the DB" mean? Is this a maintenance job where all DBs are selected and it's failing because of one DB? Please provide more (much more) detail so we can help.
-- You can't be late until you show up.
April 30, 2008 at 6:04 pm
Sounds like somebody has setup a maintenance plan and selected 'all databases' instead of selecting just those databases that need to have log backups done. So the log backups for the databases that need it are being done but the job is failing because there are 1 or more database in SIMPLE recovery model specified in the maintenance plan.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
May 1, 2008 at 6:57 am
That's what I'm thinking too. For months we had a MP running flawlessly, until someone changed the recovery option of a DB from full to simple. All the other DBs backed up fine but the plan would still show failure.
-- You can't be late until you show up.
May 1, 2008 at 10:58 pm
hi,there are around 20 dbs in this server,and all the databases recovery model is full.
only the one db we are getting following messages
Message
Error: 3041, Severity: 16, State: 1.
BACKUP failed to complete the command BACKUP LOG . Check the backup application log for detailed messages.
May 2, 2008 at 1:24 am
....and what does the backup application log say?
....also check the error log in the span during the MP gets executed......give us some more information to analyze the situation.....:hehe:
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.
May 2, 2008 at 1:59 am
Another possible reason for a log backup to fail is if you have never made a full backup of the database. As suggested, do check the SQL Server logs for more details.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
May 2, 2008 at 7:29 am
Did you create this using the GUI or did you manually create the backup statement?
Q
Please take a number. Now serving emergency 1,203,894
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply