Solved

diff.backup - OLTP/OLAP

Posted on 2011-02-18
4
1,007 Views
Last Modified: 2012-05-11
is diff backup better or adviced for OLAP (where there are batch processing and bulk inserts) because it will be easy for SQL to track what has changed since last FULL backup, instead of OLTP (like amazon.com)
0
Comment
Question by:anushahanna
  • 2
4 Comments
 
LVL 4

Accepted Solution

by:
rocky_lotus_newbie earned 375 total points
ID: 34928983
It depends on the data recovery requirements.

In OLTP when there are multiple pages in the database updated, the differential backup tends to be considerably huge which is not the case in OLAP. (The Log backups also might be huge because of the transactions)

However, data recovery is needed in both environments.

Skipping differential backups is not advisable in most cases. Diff backups help in making the data recovery process faster compared to the log backups.

Thanks,
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34929014
>>Skipping differential backups is not advisable in most cases. Diff backups help in making the data recovery process faster compared to the log backups.

you mean Full backup+diff backup+tran log backup is faster than Full backup+tran log - and only for OLAP (where there are batch processing- huge inserts etc instead of individual transactions)
0
 
LVL 15

Assisted Solution

by:Aaron Shilo
Aaron Shilo earned 125 total points
ID: 34932755
hi

i think what you should do is read this : http://technet.microsoft.com/en-us/library/cc180782.aspx

and try to develope a backup scheme relevant for your needs and limitations.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34949742
thanks
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question