SQL Server Performance

Question on SAN

Discussion in 'Performance Tuning for Hardware Configurations' started by FrankKalis, Oct 24, 2003.

  1. FrankKalis Moderator

    Hi there,

    it happens that our IT staff is asking me on hardware consideration for our datawarehouse.
    Now, what I know, is everything is on a SAN (Assume, that I don't know exactly what this is).

    Question 1: Is it possible to restore a db, even if the size of that db is larger than the free space on a single drive in the SAN?


    Frank
    http://www.insidesql.de
  2. satya Moderator

    SANs are often contrasted with less expensive Network Attached Storage (NAS) devices. SANs provide direct and exclusive access to data storage through a private Fibre Channel networking system, whereas NAS devices generally attach to a common network for the purpose of sharing files.

    I think its possible if you use split mirroed backups, refer to this linkhttp://www.sqlmag.com/Articles/Index.cfm?ArticleID=22750 for more information on split mirror backup/restore.

    HTH

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. FrankKalis Moderator

  4. satya Moderator

  5. FrankKalis Moderator

    Thanks again, when you look at my profile you might wonder why they asked me anyhow.<br />Answer is, I don't know! I don't know much about hardware, but helped them and our developers on several occasions. They just wanted to hear my opinion on this and I gave them your link. The one above I found via search before, but don't ask what from this I do understand [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />I'll bet they hire a consultant on this!<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
  6. satya Moderator

    Thought you would get more (££ or €) out of it [8D].

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  7. FrankKalis Moderator

    Might be worth considering [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>

Share This Page