Problems doing a backup with SQL Server Management Studio

[holdahl]

Have a problem when trying to do a backup in SQL Server Management Studio.

I get these two error messages:

1:
------------------------------------
| Create failed for Job 'testplan' |
------------------------------------

2:
-----------------------------------------------
| Create failed for JobStep 'testplan' |
| |
| --> An exception occurred while |
| executing a Transact-SQL statement |
| or batch |
| --> The specified '@subsystem' is invalid |
|---------------------------------------------|

do you have to install SQL integration services on both nodes to get the 'Maintenance Plan' function to work?

any suggestions?

sH

 

[mrdenny]

Yes you have to install Integration services on both nodes for the Maintenaince plans for work.

It's very annoying I know.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[holdahl]

Where is the Integration Services located on the SQL Server 2005 cd-rom?

I try to run setup to install Integration Services but I'm not allowed to install anything. It says that components are already installed.

What components do you have to choose to install the integration services?


sH

 

[holdahl]

seems to work now....