X hits on this document

113 views

0 shares

0 downloads

0 comments

33 / 48

Microsoft’s SAP ERP (R/3) System (cont)

SAP doesn’t support SQL Server Filegroups

Fan out # of files in default file group

Pro:

Absolutely easy to configure and leverage storage resources with same sized data files

No balancing at all on storage backend due to changing workload profile

Con:

Backup of databases in TeraBytes becomes more difficult

Solution:

Perform differential backup daily using backup compression against disk devices

Full Online backup at weekend against disk devices

Pull backups from disks to other storage like tape

Backups not primary restore strategy – DBM, Log-Shipping to keep duplicates

DBA-416M• ISV configurations & implementations – Lessons Learned

Document info
Document views113
Page views113
Page last viewedThu Dec 08 18:47:41 UTC 2016
Pages48
Paragraphs862
Words4327

Comments