Allways available DB

• info 58414

  Hall of Fame

  Points: 3386

  More actions

  October 9, 2018 at 5:00 am

  #364401

  Hi,
  Our DataMart (SQL2014 Enterprise) will completely deleted during etl-load from DWH several times a day (=>drop database, create table... and load from DWH). During this time (about 15 minutes) there is no database available for the consumer. Which solution is suitable for this - fast, uncomplicated and easy to maintain, Connectionstrings, same Server/Instance. (Backup/Restore ... Log Shipping ... a.s.o)
  Thanks
  Regards
  Nicole
  

• Eddie Wuerch

  SSChampion

  Points: 12538

  More actions

  October 10, 2018 at 3:12 pm

  #2008958

  Leave the current DataMart online while you prepare the new one:
  - Create a new database on the DataMart
   - ETL-load that database from your DWH while the current database is still online
   - Drop the previous database and rename your new one to the old name.

  There's still downtime, but you could shrink it to a few seconds this way.
  This will require more storage for the extra database, but shrinking outage windows is rarely free.

  Eddie Wuerch
  MCM: SQL