Veritas-bu

Re: [Veritas-bu] Controlling SQL Server agent job from remote NBU client

2008-10-10 08:55:52
Subject: Re: [Veritas-bu] Controlling SQL Server agent job from remote NBU client
From: "Michael Graff Andersen" <mian71 AT gmail DOT com>
To: VERITAS-BU AT mailman.eng.auburn DOT edu
Date: Fri, 10 Oct 2008 14:40:55 +0200
I will suggest trying to follow the revised setup for SQL on MSCS clusters for NBU 3.4, have used it with success for later Netbackup versions on different clusters
 
But this requires a netbackup client on the nodes
 
Regards
Michael

2008/10/9 wibidee <netbackup-forum AT backupcentral DOT com>

Hello

Context is MS SQL agent (in an HP Polyserve Matrix HA cluster) backing up to a LUN from a remote backup server.

We've had to removed Netbackup media server from the Polyserve cluster nodes as Polyserve panics whenever we get a tape drive failure.
So the .bak file are written to a CIFS share on a backup server, ie backed up over our network.

I need to find a way of signalling back from the post processing file of the netbackup client to talk back to the sql agent to continue truncating tables in an archive database once Netbackup has successfully backed up the database.

In the old days, when MS SQL server/Polyserve Matrix and Netbackup all sat on the same  server, i'd have been thinking of using the steps in the SQL Agent job to control this.

However, now that the Netbackup client is outside of the cluster it appears a more tricky proposition.

Hope this makes sense!

rgds

John

+----------------------------------------------------------------------
|This was sent by john.campbell AT british-energy DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
<Prev in Thread] Current Thread [Next in Thread>