February 6, 2008 at 11:30 pm
What would be the best action to take when you see the following error message
BACKUP failed to complete the command BACKUP LOG 'Databasename'. Check the backup application log for detailed messages.
Thanks in advance
February 7, 2008 at 12:42 am
like it says: "check sqlserver errorlog" !!
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 7, 2008 at 5:22 pm
what is the exact error tha you get when the backup command is fired. it might be something to do with permissions.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 8, 2008 at 1:34 pm
Run your backup again, then do a sp_readerrorlog and grab the full error.
If I were to take a random guess, I'd say it's permissions to the file system.
February 8, 2008 at 1:45 pm
check the backup application log -actually means for you to check the Windows Event Viewer Logs. The application log and the SQL Server Error Log are 'tied' together with the application log usually showing more details.
Also, look at the entries above and below that one in the SQL Server Error log.
A lot of times this error is due to drive space issues.
-SQLBill
February 12, 2008 at 3:27 am
If you created a job to back up ther db's with a third party application; it is likely that the failed job, has logged an error log, SMS will not give you much information, so you will need to check the log file which is been used by the application to log errors.
November 8, 2008 at 10:01 am
Hi
May i know how to see full detailed message, if any error and all.
basically i will use event viewer but in that we will not get full information about error messages.in that it show see application log
like that.:cool:
may i know where application log file will be tr
Thank you
Satish
November 8, 2008 at 10:06 am
Hi
May i know how to see full detailed message, if any error and all.
basically i will use event viewer but in that we will not get full information about error messages.in that it show see application log
like that.:cool:
may i know where application log file will be tr
Thank you
Satish
March 24, 2009 at 9:48 am
Take a full backup.
---------------------------------------------------
Thanks,
Satheesh.
March 28, 2009 at 3:59 pm
Erode P. Satheesh (3/24/2009)
Take a full backup.
Why?
March 30, 2009 at 2:57 am
While taking a full backup a internal status flag for full backup should get reset. Some times for some reason it will not get reset. Which will raise this error. Most of the times it can be fixed by taking another full backup where we are assuming that the flag will get reset at this backup. If the problem still exists after taking a full backup or if it is happenning for all the databases in a server microsoft has released a hot fix, http://support.microsoft.com/kb/921106.
For me it got resolved after taking a full backup.
---------------------------------------------------
Thanks,
Satheesh.
March 30, 2009 at 5:06 am
Great!Thanks for the info 🙂
June 25, 2009 at 10:52 am
This is EXACTLY the sort of useless, deliberately obscure, error message that gives Microsoft such a bad name.
I set up a Maintenance plan to do an incremental backup of a rather large DB to run nightly at 11:00 PM. I checked this morning and the folder where it was to be copied to was empty. I checked the Windows application event log, and the SQL Server event log, and got the same message: to check the backup application log. Searched both local drives for *.log files more recent than two days old, got nothing.
Any suggestions?
June 25, 2009 at 10:57 am
Have you tried running the backup manually in SSMS (IE using T-SQL)?
June 25, 2009 at 11:03 am
Did you try viewing the history for the maintenance plan? Right-click on the maintenance plan and View History.
This should show you which step failed and why.
When you say incremental, are you talking about a transaction log backup or a differential backup? You cannot perform either of these if you don't have a full backup performed first.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 15 posts - 1 through 15 (of 28 total)
You must be logged in to reply to this topic. Login to reply