Thanks for your help.

SQL Server is running under the local system account. Do we need to change just the SQL Server Agent service to a domain acccount, or should w change the MSSQL...

There is an underscore there,  prod_backup. But I tried with quotes around as suggested and have same error.  Thanks!

Well, I'm trying to teach myself all this, and it seems to take me forever!

I get for output: "Invalid drive specification {null}. The step succeeded."

when running:

exec xp_cmdshell N'xcopy /Y...

I tried his and in the job.txt file is:

0 file(s) copied

Any other ideas?

I tried running the job as suggested

exec xp_cmdshell N'xcopy /Y "D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\HCLL_Production_DB\HCLL_Production_DB_db_*.BAK" \\hclltest\prod_backup\'

It ran successfully, but still didn't copy the file over to hclltest server, no error...

Thanks so much for the help so far. This command works when run in query analyser:

exec xp_cmdshell N'xcopy "D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\HCLL_Production_DB\HCLL_Production_DB_db_200702182300.BAK" \\hclltest\prod_backup'

Now I'm trying to use it in...

I tried like this but still have invalid drive specification:

exec xp_cmdshell N'xcopy "D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\HCLL_Production_DB\HCLL_Production_DB_db_200702182300.BAK" \\HCLLTEST\D$\HCLL\PRODBACKUP\HCLLProductionDBdb20070218.BAK'

If the syntax is ok, could this be a permission issue? The folder...

We changed the registry to the target path, but I still get the "apply to target server failed for job" message.

Could I still have something set up wrong? I...

I think maybe I haven't configured Integration Services on the Cluster correctly. I was trying to follow this document: http://msdn2.microsoft.com/en-us/library/ms345193.aspx.

I didn't understand the registry replication part. What should be...

Sorry, nevermind. I see in troubleshooting section that the files are asr.sif and asrpnp.sif  If any different please let me know. Thanks!

I've added cluster group resources for DTC and SSIS, but I still am receiving "Apply to target server failed for job" error.  Any other ideas? Thanks!

So I should create a cluster resource as DTC, type Distributed Transaction Coordinator, with the dependencies you mentioned?

It is active/passive cluster. I have already installed SSIS on both node servers. So...

Actually, I set up the backup plans using the Maintenance Plan Wizard. I can't create any kind of jobs using New Maintenance Plan which is what I need for cleanup...

I tried that but when I got to the screen to select what services to install, on the primary node server Reporting Services is greyed out so I can't select...