Back up databases

Back up both read-only and writable databases.

Pay special attention to the type and the data that is residing in the SQL server. This information will be useful in the event you need to restore one or more databases.

Back up read-only databases

Read-only databases are databases supplied by Verisk which cannot be updated by the client. A one-time backup is required of these databases, and the backup should be readily available in case a database needs to be restored. Examples of read-only databases include:

AIRAddressServer AIRLossCost
AIRDBAdmin AIRMap
AIRDQIndustry AIRMapBoundary
AIREventInfo AIRPropertyExposure *if licensed
AIREvx AIRReference
AIRGeography AIRSpatial
AIRIndustry

Back up writable databases

Databases that are not Verisk-supplied read-only databases contain client data and should be backed up regularly. Examples of working databases include:

AIRCompanyLoss AIRPropertyExposureHelper *if licensed
AIRDowngradeHelper AIRReinsurance
AIREvents AIRResult
AIREvents_50k

AIRResultRe

AIREvents_HIST

AIRSecurity

AIRExposure

AIRSpatialWork *if licensed

AIRExposureRe

AIRUserMap *if licensed
AIRExposureSummary AIRUserSetting
AIRGlobalSetting AIRUserSpatial*if licensed
AIRMapBoundary AIRUserSpatialWork *if licensed
AIRProject AIRWork

Verisk recommends:

  • Results databases be in a simple recovery state at all times.

  • Avoid running periodical transactional or differential backups on a Results database.

  • Perform a full back up of Results databases at the end of the analysis to save the results for the future.