We use the Tivoli suite of products to do just that. Rememebr that you are
backing up the clustered instance of SQL, and not the physical nodes when you
set up your back ups. You have to be able to authentictae to your back up
server as the clustered instance from both nodes....if you are lucky, the
same node will always own the resources...but if you have a failover, you
need to be able to back it up from the other side. We have 7 clusters set up
in just this fashion...A/A clusteres are a tad more difficult as you have to
be able to authenticate to the back up server as both clustered instances
from both nodes...twice the config files, and such.....
[quoted text, click to view] "Uttam Parui[MS]" wrote:
> Hi Ashok,
>
> Backing up your SQL database in a clustered environment is not different from a normal server (although it can be complex if the db is in terabyte range). You can still use the SQL Server Agent jobs/maintenance
> plans to backup your database. More often than not, it is easiest to first back up to disk. Create a cluster disk share so in the event of a fail over, all nodes will have access to the backup share. Do NOT attempt to
> backup to any LOCAL drives. After the database is backed up, it should be copied to another location, backed up to another medium such as tape, and then archived in an offsite location after it is tested and verified.
>
> Apart from backing up your SQL Server databases, you need to backup your server cluster. You can use the Backup or Recovery Wizard to back up cluster nodes. For detailed information, please refer to
>
> Backing up and restoring server clusters
>
http://www.microsoft.com/resources/documentation/WindowsServ/2003/standard/proddocs/en-us/Default.asp?url=/resources/documentation/WindowsServ/2003/standard/proddocs/en-us/sag_mscsusing_9.asp
>
> Best Regards,
>
> Uttam Parui
> Microsoft Corporation
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security. >
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
>
http://www.microsoft.com/protect >
http://www.microsoft.com/security/guidance/default.mspx >
>
