Give me free advice !!! (mirroring , Replication) ?

  • Hi there

    I wanna give a online backup from my SQL server 2008 and i don't know how to do it !!!

    I want design a king of back up which when my main sql server goes down with changing ip address in client apps

    they work with out any delay and lost data !

    can anyone help me in this case ?

    I've done a lot of search on the net and i got 2 solution which is cool for me but none of them are useful because

    my SQL DB has file-stream and mirroring doesn't support it !!! 🙁

    and as far as i know replication works like this !

    1 - publisher

    2 - subscriber

    which subscriber is read only ? and when my publisher (main SQL server goes done the subscriber won't work 🙁 )is it correct ?

    any suggestion ?

  • s.kianpoor (7/23/2013)


    which subscriber is read only ?

    Incorrect.

    and when my publisher (main SQL server goes done the subscriber won't work 🙁 )

    Incorrect.

    As for suggestions, maybe a lot more reading...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • tnx for help

    u tell me !

    i have one sql server with filestream and i want take realtime backup on another server !

    how can i do this ?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply