From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Implementing a data warehouse using a SQL database engine

Implementing a data warehouse using a SQL database engine - SQL Server Tutorial

From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Start my 1-month free trial

Implementing a data warehouse using a SQL database engine

“

In this section I'd like to talk about implementing a data warehouse and specifically some places where we might implement a data warehouse differently than we would implement a transactional database. We'll look at our adventure works dw 2012 data warehouse. I'll right click on that and go to properties. One of the properties I want to talk about is in the category of options, and that is the recovery model. Most production databases that are transactional, ones that involve change in data, are typically set to the full recovery model, meaning a detailed transaction log is kept. In the case of a disaster, we can often recover missing data from that transaction log. But in a data warehouse, we're not going to be changing data. Therefore there's going to be very little activity in the transaction log. Because of that I can go ahead and set the recovery model to simple. It also means that the location of my transaction log is no longer an important decision. If I go here under files I…

Contents