Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2004
    Posts
    10

    Unanswered: active/passive w/o shared disk array

    can you have an active/passive without a shared disk array?

    can you have an active/active without a shared disk array?

    Where are the actual db files stored?

    thanks

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    No you'll need to setup shared disks
    MCDBA

  3. #3
    Join Date
    Jun 2004
    Posts
    10
    where are the db file stored? On the sared disk?

    Can I set up a regular server as a "shared disk" instead of buying expensive disk arrays such as netapp? Any other options?

    thanks

  4. #4
    Join Date
    Feb 2005
    Posts
    4
    Yes, db files are stored on shared disk, not local

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I think Microsoft advises against using a NAS device, or a shared network drive for SQL Server files. I think it can technically be done, but the chance of corruption of the database is inordinately high.

  6. #6
    Join Date
    Sep 2004
    Posts
    21
    Without a shared disk array, when one server goes down, how does the other server get to the data?

    SAN is the perferred, although, we have 2 cluster environments here running with DELL PowerVaults and things have been going well so far.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •