X hits on this document

158 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 views158
Page views158
Page last viewedSat Jan 21 17:32:28 UTC 2017
Pages48
Paragraphs862
Words4327

Comments