Restauration

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.