Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi Scott,
I would use the same process with your PI system, but SQL Server does not have an Offline backup.
The recommended solution for SQL Server is:
1. Weekly Full Database Backup.
2. Daily Differential Backup.
3. Multiple Transaction Log backups daily.
Monthly File system backup
In the case of a disaster you would restore the last Full backup, then Last Differential Backup and then all the Transaction logs since the last Differential backup.
Regards
From: scottslater via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 25 August 2010 20:01
To: D. Caddick
Subject: RE:[sap-basis] SAP dual stack on sql server 2008 backup strategy
Posted by scottslater
on Aug 25 at 3:03 PM Mark as helpful
Thanks guys!
In my single stack systems( ECC in unix oracle) , we do once a month file system ( which includes /usr/sap , oracle executables) backup , and full online database brbackup on the daily basis. Recovery procedure has been tested many times on these single stacks.
In dual stacks BI systems (unix ,oracle ), we do daily online and the weekend offline
brbackups. We backup /usr/sap and oracle executables once in a month or so. We don't use NWDI and all development is getting done in ABAP system only.
In dual stack PI ( sqlserver 2008 , windows 2008) , should I do the database and /usr/sap backup together? Also to backup /usr/sap , is it recommended to shutdown and sap and the database?
---------------Original Message---------------
From: scottslater
Sent: Wednesday, August 25, 2010 11:14 AM
Subject: SAP dual stack on sql server 2008 backup strategy
> What is the best recommended way to backup a dual stack system in sqlserver in a local backup drive?
> Did use the sql server management studio to do the full and transaction log backup.
> Tried to use db13 to do the full database backup but I don't see a option to create a backup device for the the local drive. Thanks for all your help on this.
| __.____._ Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  D. Caddick
SAP Basis Top Contributor
Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement Related Content White Papers
In the Spotlight  _.____.__ |
Mark as helpful
