March 13, 2013 at 5:57 am
Hi,
Tlog backup failed and no errors are written error log and application logs as well..
when try to editing existing maintenance plan as below errors display
"Microsoft SQL Server Management Studio is unable to load this document Error Loading from xml. No further detailed error information can be specified for this problem because no Events Objects was passed where detailed error information can be stored"
Error
SQL Server Scheduled Job 'Tlog_Backup.Subplan_1' (0xDFA7450D1A79F54291B8D3F5AA540950) - Status: Failed - Invoked on: 2013-03-13 15:52:00 - Message: The job failed. The Job was invoked by Schedule 14 (tlog). The last step to run was step 1 (Subplan_1).
pl. suggestion me how to resolve this issues?
thanks
ananda
March 13, 2013 at 12:30 pm
A couple of points:
Verify that the version of your client tools are the same or greater than the version of SQL Server you are connecting to. These kinds of errors usually indicate that the client has not been upgraded.
To view the actual error, you need to review the maintenance plan history - not the agent job history. To view the maintenance plan history, right click on the maintenance plan and view history.
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
March 13, 2013 at 11:41 pm
As per your advise me, No error history available in M.Plan history.
http://support.microsoft.com/kb/919224,
Error will be resolved after installing latest SP in SQL 2K8.
Version - SQL Server 2008 standard edition 32 bit with SP1 installed
OS - windows 2008 standard edition 32 bit
should I apply SP3 on this server?
Thanks
March 14, 2013 at 12:20 am
Has the maintenance plan worked in the past?
Does it throw the same error no matter where you try to open it (your desktop or from the server)?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 14, 2013 at 12:59 am
ananda.murugesan (3/13/2013)
Hi,Tlog backup failed and no errors are written error log and application logs as well..
when try to editing existing maintenance plan as below errors display
"Microsoft SQL Server Management Studio is unable to load this document Error Loading from xml. No further detailed error information can be specified for this problem because no Events Objects was passed where detailed error information can be stored"
Error
SQL Server Scheduled Job 'Tlog_Backup.Subplan_1' (0xDFA7450D1A79F54291B8D3F5AA540950) - Status: Failed - Invoked on: 2013-03-13 15:52:00 - Message: The job failed. The Job was invoked by Schedule 14 (tlog). The last step to run was step 1 (Subplan_1).
pl. suggestion me how to resolve this issues?
thanks
ananda
Any change in the DB level from the day it worked fine and day it didn't work.
It could be anything. Such as service account change. Adding of new db with full recovery model and without having a full backup taken. And the database recovery model changed from full to simple.
March 14, 2013 at 3:29 am
It was working fine last one year, Y'day Tlog backup failed after 1:30 PM and received mail alert for Tlog backup failed due to above error which is posted in first.
I want to check in M.Plan history log but no logs are available, it was only successed info.
Today server is restarted and connect throu sa user then reconfigure new M.Plan then SQL jobs are working fine both full & tlog backups...
thanks
ananda
March 14, 2013 at 4:51 am
Which databases failed the Transaction Log backup? You have offered no information on that point. I suspect you have tried to backup the transaction log in a system database or included a database in your transaction log backup that is running in the simple recovery model.
Another idea might be the fact you have included a transaction log backup for a database for which there is no associated full backup.
If that isn't the case then you need to provide a great deal more information than what you have given us.
March 14, 2013 at 5:56 am
All the database in FULL recovery mode.. and configured FULL backup including system database..
Tlog configured for all the database exculding system database.. Tlog failed y'day after noon after that I changed SIMPLE recovery mode for all user database for contolling log grows and disabled Tlog backup as well. Y'day full backup was also failed for all database in mode SIMPLE.
so there is problem in SSIS load pakages.
resolutions
creating new M.Plan for both FULL backup & Tlog backup, then changed FULL recovery mode and taken backup throu SQL Jobs and following taken Tlogs backup also.. so after creating new M.Plan problem is relsolved... But existing M.Plan was not working as above errors.
March 14, 2013 at 5:03 pm
If creating a new maintenance plan resolves it, then it is just that the maintenance plan got corrupted. That happens from time to time with maintenance plans. That is also a very good reason to use scripts rather than the maintenance plans;-)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply