July 22, 2010 at 8:34 am
Hello,
i'am unable to find the solution, i hope you can help me.
we have two sql server. We want to start a job (automatic per sql agent) on server A. This job should execute a command on server B to backup a database.
After this backup is complete we want to start serveral other steps. i know we can do this with two jobs. one on server B for backup and one for server A with the other steps, but we want one job on one server.
is that possible? and if so, could you please give me the syntax? both server are in the same domain, and running under a domain account, so i'm able to grant the necessary rights.
thanks
Bernd
July 22, 2010 at 10:28 am
this is a kind of hokey way to do it but I have done this in other scenarios where I needs to do a similiar function. create a SP on Server A that does the backup. on Server B you execute the SP rather than trying to call the backup directly.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
July 22, 2010 at 10:50 am
As per the requirement, you can create a job on Server A, that will call d Backup-proc on Server B.
like (exec servernameA.databaseA.dbo.backup_proc)...
July 22, 2010 at 11:01 am
You can easily do this on ServerA with a command line call. Server A is a client of server B, so they can use SQLCMD -E -S "ServerB" -Q "Backup DAtabase xx"
That's if your SQL Agent (or proxy) login on A has rights to connect to B.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply