How do I set up a job on SQL 2000 to back up a database on other computers in my domain to my computer?

I am trying to create a job on SQL 2000 that will allow me to backup databases from 3 other computers in my domain. all running SQL 2000. i need help writing the T-SQL Statement to insert in the job step.
Powered by Y! Answers

1 comment

  1. The simplest would be to setup linked servers, then through SQL Agent set up a job that executes “TargetServerName.master.dbo.sp_executesql” with a TSQL backup statement in the parameter (code it as if you were typing it in query analyzer on the target machine). If upgrading to SQL 2005 is an option, then there are some very flexible SMO options that you can probably leverage.

Leave a comment