Post reply

Files and File Groups

  • August 16, 2009 at 8:44 am

    #1039958

    Thanks for correction Gail. 🙂


    Pradeep Singh

  • August 16, 2009 at 9:32 am

    #1039961

    There are a few issues with snapshots.

    they don't stay up to date. They are a point in time. To update it, you need to either drop the snapshot and recreate it, or create a new one (new name). both will interrupt users.

    If you log ship, the same thing, if you want to restore a new log, you interrupt users.

    If you need a secondary reporting solution, replication is probably your best bet.

  • August 16, 2009 at 9:48 am

    #1039962

    Steve Jones - Editor (8/16/2009)

    There are a few issues with snapshots.

    they don't stay up to date. They are a point in time. To update it, you need to either drop the snapshot and recreate it, or create a new one (new name). both will interrupt users.

    They can also add load to the mirror, impacting how well it manages to stay up to date. If the mirroring is synchronous, that may also impact the principal.

    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

  • August 16, 2009 at 10:32 am

    #1039968

    Steve,

    Thank you for the reply. I am trying to use FG to reduce the size of backup and restore that's all. In this way I can keep loading one particular history table from the production to the secondary server to run a dashboard to watch the user activity in a periodic time, assuming that table resides alone or with other tables in that particular file group. I guess using Enterprise Edition and File Groups I can achieve this. I can work on reducing the load on Production by limiting my transaction between primary to secondary server. Only load I will be facing at the Production is the online back up of file group. I wish there is a log shipping at File Group Level, or snapshots at file group level so the load the production could be even lesser than backing up the whole file group.

    I appreciate every one's thought. I think I have answers to my research.

    -Shihab

Viewing 4 posts - 16 through 18 (of 18 total)

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