DB13 backup for SAP on MSSQL2005

[Former Member]

Hi Experts,

Our SAP systems are running on MSSQL2005. I have to prepare backup strategy to tape device from DB13.

Kindly provide me the documentation/link for more details about DB13 backup for SQL2005.

Regards,

Amit.

[Former Member · Accepted solution]

Good Practice.

1. Hourly T-Log Backup.

2. Daily Online Backup.

3. Weekly Offline Backup.

http://help.sap.com/saphelp_nw70/helpdata/EN/f2/31add4810c11d288ec0000e8200722/frameset.htm

Regards,

Nikunj Thaker.

Edited by: Nikunj Thaker on Dec 8, 2008 3:13 PM

[Former Member · Accepted solution]

how to take offline backup, do i need to stop system? i am used to take backup from SAP DB13 but system doesn't stop during fullback backup. Am i following right procedure or its wrong practice, i think i need to stop sap??

Can u suggest something on the same.

Mani

[Former Member · Accepted solution]

For Offline backup. You have to stop SAP Instance. Database Instance.

For SQL Server SAP not providing Offline backup.

You shutdown SAP Instance, Database Instance/services and use NTBackup or other Backup solution.

Regards,

Nikunj Thaker.

[Former Member · Accepted solution]

you mean i have to stop everything SAP and Database instances from SAP MMC ?

If i took Fullback backup through DB13 (online backup), can i restore my system from the same backup or i need to have any other backup too???

thanks

Mani

[Former Member · Accepted solution]

>

> you mean i have to stop everything SAP and Database instances from SAP MMC ?
yes
> If i took Fullback backup through DB13 (online backup), can i restore my system from the same backup or i need to have any other backup too???
You can able to restore same backup. 
>  thanks
> Mani

Offline backup includes your system full backup not only database its include (OS, SAP Instance, DB Instance )

Regards,

Nikunj Thaker.

[Former Member]

thannks

[Former Member]

You can use Tivoli Data Protection(TDP) for SQL or any other third party tool for backup.This will ease your job and it is automated.

If you donot want to use Third party tool then backup can be configured from DB13 or from SQL Server Configuration Manager.

For production system which has high availability the backup strategy should be....

1. Daily Online Backup

2. Hourly T Log backup (For BI system T Log backup should be taken in every 30 mins)

3. Search for an outage where you can take Offline backup.