Re: Cluster backup

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rodney R. Fournier [MVP] (rod_at_die.spam.die.nw-america.com)
Date: 12/01/04

  • Next message: Tam O'Shanter: "Re: Cluster backup"
    Date: Wed, 1 Dec 2004 14:12:16 -0600
    
    

    You are correct, its a bad idea :) The Quorum drive would have to be a
    dependency for SQL. Which would mean one group for basically everything. If
    the backups filled the disk, the cluster would not be happy.

    A good idea is use the MP to a disk, and then backup to some kind of tape.

    Cheers,

    Rod

    MVP - Windows Server - Clustering
    http://www.nw-america.com - Clustering
    http://msmvps.com/clustering - Blog

    "Tam O'Shanter" <Tam@Oshanter.com> wrote in message
    news:b6prd.6024491$6p.961500@news.easynews.com...
    > Quick question....
    >
    > 2 node active/passive (excuse the terminology....) cluster.
    >
    > My network admin wants to have my SQL backups (performed via. maint. plan
    > nightly) stored on the quorum drive.
    >
    > We are also performing log shipping at 15 minute intervals to an offsite
    > server.
    >
    > I think storing the backups on the quorum drive is a bad idea as if the
    > disk
    > array dies completely, we have no backup.
    >
    > Also, would that scheme not necessitate adding the quorum drive as a
    > resource to the SQL Server?
    >
    > Comments and thoughts please.
    >
    > Thanks in advance.
    >
    > B.
    >
    >
    >


  • Next message: Tam O'Shanter: "Re: Cluster backup"

    Relevant Pages

    • Re: Cluster IP Address change
      ... I've heard the same story from...after not hearing this in 2 years of SQL ... After changing sql ip address resource & sql name resource came online but ... sql server resource was failing. ... MVP - Windows Server - Clustering ...
      (microsoft.public.sqlserver.clustering)
    • Re: Side-by-side upgrade - moving master, msdb and model
      ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
      (microsoft.public.sqlserver.clustering)
    • Re: 4 Queries about DB clustering
      ... I support the Professional Association for SQL Server ... First you install MSCS (Clustering). ... >> on a single logical device physically connected to all host nodes. ...
      (microsoft.public.sqlserver.clustering)
    • Re: Choosing correct high availability setup
      ... normal SQL startup, DB integrity check, roll back non-committed ... MVP - Windows Server - Clustering ... Basically there will be an Access database that arrives via FTP at ...
      (microsoft.public.sqlserver.clustering)
    • Re: How to install service pack 3a on a failover cluster
      ... MVP - Windows Server - Clustering ... We have two instances of sql running so I ... > the second node and rebooted the first node. ...
      (microsoft.public.sqlserver.clustering)