Was this page helpful?


    Table of contents

    Restauration of DTW database

    We do not rebuild the database of the data warehouse .

    Restoring the data base NewtestDWH runs succinctly as follows:

    • Stop SQL jobs who open connections to the database to be restored
    • Stop related Windows services
    • Restoring the database
    • Upgrading pointers NMC / DWH
    • Re-enabling and checking performance of jobs and services
    • Check system with NMC supervision

    The datas collected between crash time and restore time are not automatically inserted.
    Be sure to backup your transaction log files " NewtestDHW_Log.ldf " .
    This operation can be critical, we strongly recommend to call the Newtest support for any database backup restoration after a crash.
    Any restoration of database could causes a loss of less than 24 hours of datas.
    Newtest support could help you to re-inject missing datas if time elapsed between crash and backup is less than the value of the " NbDays_Purge " parameter which is 4 days by default.


    Was this page helpful?
    Tag page (Edit tags)
    • No tags
    Page statistics
    1997 view(s), 1 edit(s) and 1235 character(s)


    You must login to post a comment.

    Attach file