Backup over LAN or FC

Discussion in 'microsoft.public.sqlserver.clustering' started by anxcomp, Mar 22, 2009.

  1. anxcomp

    anxcomp Guest

    Hello,

    I have two node A/A cluster, I backup all databases (from node 1 and node 2)
    over the LAN network (1GB) to backup server (example BACKUP DATABASE DB1 TO
    DISK = '\\BackupServer\Share' and so on), it is not so fast and secure way.
    I'm using native SQL Server backup system.

    I'd like change this and backup database over FC network, so I'm going to
    add new disks to SAN Array, change MSCS and add new resource "File Share"
    with PhysicalDisk, IPAdress, NetworkName and backup to "local" disk it should
    be more faster.

    I'm wondering about:

    1. impact on other "PhysicalIDisk" resources, do you see any bottleneck in
    this situation (where)?

    2. in one time only one node can be owner of that resource "Backup", how
    second node can get this resource (over \\NetworkName\Disk$ - this "share"
    mean copy over LAN or over FC it is not clear for me ?)

    Thanks in advance.
     
    anxcomp, Mar 22, 2009
    #1
    1. Advertisements

  2. anxcomp

    anxcomp Guest

    Hello,

    All my servers are in the same local AD domain.
    Thanks for tips.
    All databases are about 100GB backup takes abut 3hours but databases still
    growing and time will grow too.

    Tell the truth time is on the second position at my problem list :(
    first place take below problem:

    -----------------------------------------------------------------------------------------------------------
    BACKUP DATABASE - Operating system error 2 [5] [64](error not found).

    http://www.microsoft.com/communitie...-1eb323dfd95a&lang=en&cr=US&sloc=en-us&m=1&p=
    -----------------------------------------------------------------------------------------------------------

    Unfortunately mapped drives not help I get randomly the same error message,
    so this real reason I want change backup over LAN.
    If I well understand backup node2 over \\NetworkName\Disk$ (standalone group
    on MSCS as I wrote on the first post) will go through public interfaces node2
    and node1,
    so in this case bottleneck still be LAN bandwidth ?
    I know it will be probably best way.
     
    anxcomp, Mar 22, 2009
    #2
    1. Advertisements

  3. Another option for you if you have budget on some tools; you can look at the
    RedGate or LightSpeed backup tools.

    I have yet to convince people to let me use them; but I have heard wonders
    about these tools.

    And I wouldn't put the drive in the Cluster configuration if you want to
    back it up; then it will keep failing back and froward and you'll have to go
    through DSN redirect to back it up; just attack it directly to Node 1, and
    access it using \\Node1\BackupFolder$

    Thanks.
    --
    Mohit K. Gupta
    B.Sc. CS, Minor Japanese
    MCITP: Database Administrator
    MCTS: SQL Server 2005
    http://sqllearnings.blogspot.com/


     
    Mohit K. Gupta, Mar 23, 2009
    #3
  4. anxcomp

    anxcomp Guest

    Thanks, I like native backup but worst thing with native is missing
    compression :(

    I don't understand why MS include compression only in SQL 2008 EE, I think
    it should be available in all editions.
     
    anxcomp, Apr 4, 2009
    #4
  5. I agree; in 2008 they have included alot of new functions but most are in EE.
    I am not sure why didn't they spread them out a bit more.

    You can look at RedGate backup or LightSpeed backup; both of these tools are
    great for SQL Backups.

    Thanks.

    --
    Mohit K. Gupta
    B.Sc. CS, Minor Japanese
    MCITP: Database Administrator
    MCTS: SQL Server 2005
    http://sqllearnings.blogspot.com/
     
    Mohit K. Gupta, Apr 5, 2009
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.