October 9, 2018 at 5:00 am
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 🙂
October 10, 2018 at 3:12 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply