What error message are you getting in your error handler?

You need to step thru you code and try and capture some additonal information, for correct me if this is wrong...

Why don't you use a registered server as opposed to a Linked Server?

Also backing up over the network is very slow.

Are the Database Servers in question on the same Network...

You xcode that you use in your .NET code to generate you paramter collection is flawed and thus generates a syntax error.

Your Stored Procedure if fine.

DECLARE @ART_ID int

SET @ART_ID...

Why are you using a Linked Server?

Why not use maintenance task or SSIS?

Does it time out when you run your code from Query Analyze ar as a Stored Procedure?

It appears that you have the wrong syntax with the paramater in your .NET Code.

If you copy & paste the output frpm Profiler and get an error than it is...

Again., my account has been comprimised...

My account has been comprimised...

This was posted on error om my part.

Thank you for your contributions to this Forum.

Regards...

Thank you for the clarification...:-)

xxx

Jeffrey,

Excuse me Sir but Im not sure that I understand your post?

Regards,

WelshS

After examining your initial post it is clear that you approach is severely flawed.

I do not like to Criticize other members but I suggest that you Goggle this topic if...

I know what backups were performed and when. You can query the system tables.

I used the file System object in addition to the system tables to verify existence of...

I routinely used DTS Packaged to refresh the Development,Test & QA Environments.

I also wrote SSIS packaged to do the same on as routine basis. I would take the backup from...

Well thank you all for a very positive and constructive dialogue. 🙂