ISO ideas for creating a Mirror''d DB on the fly

• Express12

  SSCoach

  Points: 18526

  More actions

  April 4, 2007 at 2:50 pm

  #153508

  Looking for some idea's to accomplish the following:

  We have our active reporting DB called REPORTS

  Each day we need to recreate/repopulate the contents of REPORTS w/ the capability to roll back to the previous days version "IF" the recreation/population process should fail ---  AND -- w/out any downtime.  (therefore a Litespeed backup of REPORTS prior to the build for contigency purposes via RESTORE is unacceptable)

  SO.. how are other folks accomodating the flip of a stage DB to a real DB, in a split second?   

  BT

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 4, 2007 at 3:07 pm

  #698655

  Here is a rough outline:

  1. Create an empty database with all requisit tables, call it reportdb_new.

  2. Load reportdb_new.

  3. If load successful:

       Drop all active connections to reportdb

       Rename reportdb to reportdb_old

       rename reportdb_new to reportdb

       backup and delete reportdb_old (or whatever you want to do)

  4. If load not successful, keep reportdb as is and figure out what went wrong with the load.