Hi
Yep! sure do ... ALOT
Examples:
Physical Computers are SERVER1 adn SERVER2. These are 2 Nodes in a
Cluster.
The VIRTUAL SERVER Name, that all users connect to is called
SQLVIRTUALNAME.
1 x Policy for the SERVER1 and SERVER2 Nodes. I backup ONLY the local
disks connected to the servers. (ie: C, Drive or any other "local"
partitions that are physically connected to the Server (I call this
local storage as well!)
1 x SQL Policy, configured for the virtual server name SQLVIRTUALNAME.
I do not backup any other physical or virtual disks that are part of the
cluster.
Hope this helps.
-----Original Message-----
From: veritas-bu-bounces < at > mailman.eng.auburn.edu
[mailto:veritas-bu-bounces < at > mailman.eng.auburn.edu] On Behalf Of Mellor,
Adam A.
Sent: Wednesday, February 13, 2008 9:15 AM
To: veritas-bu < at > mailman.eng.auburn.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.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
This email (including any attachments) may contain confidential and/or
privileged information or information otherwise protected from disclosure.
If you are not the intended recipient, please notify the sender
immediately, do not copy this message or any attachments and do not use it
for any purpose or disclose its content to any person, but delete this
message and any attachments from your system. Astrium disclaims any and all
liability if this email transmission was virus corrupted, altered or
falsified.
---------------------------------------------------------------------
Astrium Limited, Registered in England and Wales No. 2449259
REGISTERED OFFICE:-
Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
_______________________________________________
Veritas-bu maillist - Veritas-bu < at > mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
