Recovery Models for a Data Warehouse

As Data Warehouse is not real time its back-up can be supported using the following types of Recovery Models-

• Full Recovery Model:

Here all the transactions are fully logged with all the associated data and back ups are made regularly. Full is selected when point-in-time recovery is needed.

• Bulk Logged Recovery Model:

Here the T-SQL commands are logged but without all associated data. It permits high-performance bulk copy operations such as Index creation/bulk loading of text/XML.

• Simple Recovery Model:

SQL server reclaims log space for committed transactions.