Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    Unanswered: Restoration of VLDB

    Restoring a large database nightly.
    What is the best way w/out replication to restore changes of a vldb.
    Any suggestions....

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    yeah


    Don't

    Try log shipping

    If not that, then try triggers

    If not that, the write to a table, and replay it like a log

    Or do Deltas

    When you say VLDB (another nonsense term made up by people), how big are you talking about

    Oh, and maybe try just a dump and restore
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    yeah

    about 400 gigs .... .
    will have to look into log shipping....
    its 2005 and standard edition

Posting Permissions

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