Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lebedev
Posting Yak Master
126 Posts |
 Posted - 2007-08-14 : 12:03:37
|
| We have a live OLTP database for which we create full backups every week and differential backups every day. Recently we added an OLAP database, which we need to update daily with changes from the live database.This is the process we are planning to use.1. Restore last full OLTP backup.2. Apply the last differential OLTP backup.At this point we should have a replica of the live OLTP database.3. Update OLAP database based on the OLTP replica database.4. Delete the OLTP replica database.Two questions.1. If different from the process above, how is this OLTP-to-OLAP transformation typically done in the industry?2. What is the best way to implement this process with SQL Server 2005?Thanks. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-14 : 12:15:25
|
| We go through the same process. Our OLAP db is refreshed everyday with the OLTP db.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
lebedev
Posting Yak Master
126 Posts |
Posted - 2007-08-14 : 12:21:41
|
| How did you set up your process in SQL Server 2005?Anybody else wants to share? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-14 : 22:23:34
|
| You can set sql job to restore db. |
|
|
|
|
|
|
Best backup/restore (OLTP/OLAP) practices in 2005