Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
snerallapally
Starting Member
2 Posts |
 Posted - 2008-11-05 : 14:08:53
|
| Hi,I am maintaining a two node MCS cluster with SQL 2005. I created Maintenance plans on the database. But my maintenance plans are getting failed. I am getting following errors in the event log.Event ID 107 : Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.Event ID 12291: Package "MaintenancePlan" failed.I am aware that Maintenance plans uses Sql Server Integration Services (SSIS) and SSIS is not cluster aware. So can anyone tell me how to go about solving the above issue? I have to be able to execute maintenance plans for the database.ThanksSwetha |
|
|
Elisabeth Redei
Starting Member
15 Posts |
Posted - 2008-11-05 : 15:14:39
|
| Hi,You can setup SQL Server Agent to run the package. Steps are described in http://support.microsoft.com/kb/942176 "Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service"HTH!/Elisabethelisabeth@sqlserverland.com |
 |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-11-05 : 19:13:09
|
| Update this file MsDtsSrvr.ini.xml in Bin folder with active node information |
|
|
|
snerallapally
Starting Member
2 Posts |
Posted - 2008-11-06 : 14:57:37
|
| Thank you very much for the reply. I created a SQL Server Agent Job to execute maintenance plan. I am not getting any errors in the Event Viewer. Job is running successfully. But the backup / transactions files are not getting created.I checked if the file is getting created in the default directory. But no luck.So could you please help me with that?ThanksSwetha |
|
|
|
Elisabeth Redei
Starting Member
15 Posts |
Posted - 2008-11-07 : 01:10:13
|
| Hi Swetha,Any information in the output files or in the history of the job? Could you pass on the package (right click the job and View History)?Can you set up a test T-SQL job that does only this:BACKUP DATABASE yourdatabase TO DISK = 'put the path you are using in the package here'.If that works, try to paste the T-SQL from your maintenance plan (for the BACKUP part) into a job and see if that works.The reason for this tests is I want to rule out permissions and/or some setting in the package./Elisabethelisabeth@sqlserverland.com |
|
|
|
|
|
|
Maintenance Plans failed on SQL 2005 Cluster