We have an active/active SQL cluster with two virtual SQL instances.  We 
configured a SQL policy to back up the virtual SQL instances.  We also have a 
Windows policy to back up the OS'es on each node.

-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu 
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Mellor, 
Adam A.
Sent: 13 February, 2008 4:15 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] MSSQL Agent Backups


Good evening,

We will be using the NBU Agent for backing up MSSQL databases
(instances),

<RANT Portion>

        Configuring the policies in netbackup (6.5.1 btw) following the
"Veritas Netbackup for Microsoft SQL Server Administrators Guide" :-)
going through configuring the systems in a Microsoft Clustered
environment.

        My Colleague (windows admin) and I (unix admin) are
confused/arguing with 1 aspect and I would like to ask other's how they
have configured it.

        In the doco (pg125 item 3) it says to "Create a standard backup
policy (say, STDPOLICY). Add all physical names in the cluster into the
client list of STDPOLICY."

        My interpretation is, this is to create a "Windows-NT" Type
policy to ensure you are backing up the cluster node.

        How my colleague has configured it "under instruction from
symantec I understand" this is a "Standard" type policy (aka Unix/Linux)
that SQL requires.

</RANT Portion>


Back to my question, How have others configured SQL agent ( and I
suppose the filesystem as well) Policies for MSSQL server in clustered
environments ?

Adam Mellor
Senior Unix Support Analyst
CF IT TECHNOLOGY SERVICES
Woodside Energy Ltd.

NOTICE: This email and any attachments are confidential.
They may contain legally privileged information or
copyright material. You must not read, copy, use or
disclose them without authorisation. If you are not an
intended recipient, please contact us at once by return
email and then delete both messages and all attachments.


_______________________________________________
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