Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1047
  • Last Modified:

diff.backup - OLTP/OLAP

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
anushahanna
Asked:
anushahanna
  • 2
2 Solutions
 
rocky_lotus_newbieCommented:
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
 
anushahannaAuthor Commented:
>>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
 
Aaron ShiloChief Database ArchitectCommented:
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
 
anushahannaAuthor Commented:
thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now