Schedule SAP backup using SQL database **urgent help**

[Former Member]

Hi,

We have installed CRM5.0 on SQL2005 database at first time. My concern is in oracle database we schedule through DB12 twi types of backup Onlie and offline.

But in SQL backend how many types of backup? is that same like online and offline.

Can we schedule the backup through DB13? or do we need to schedule throgh SQL level and OS level.

Please suggest backup strategy using SQL backend.

Thanks

Lisa

[Former Member]

The best SQL server backup strategy is:

Your database needs to be in full recovery mode. ( You will find this in the database properties )

Full database backup once per day ( to tape of course ).

Backup log between the database backups, every 2 hours. Backup the log to file. For security reasons place the file in other server in the network or in a dedicated drive in the server.

After the full backup is completed, copy the backup log file to a tape. The first log backup must initialize the file an restart the backup log process.

[Former Member]

Hi,

Currently client not bought tape. Can we schedule OS level backup till that time .

I mean we will take file system backup at OS level then SQL backup.

please suggest.

Thanks,

Lisa

[Former Member]

Hi Lisa,

You can schedule SQL backup only. Most important data is in SQL data files. OS doesn't change often SAP bins.

Regards,

Marcin Gajewski

[clas_hortien]

Hi,

you can backup to disk (even on the network). Create

a backup device like

USE master

EXEC sp_addumpdevice 'disk', 'mydiskdump', '
srvname\share\dump1.bak'

The startup account of the SQL Server Service has to have full access to the network share or directory to start and complete the backup.

Best regards

Clas

[Former Member]

Hi N.P.C,

Thanks for your reply.Can you please send me the document for this . I have no idea on this.

- Lisa

[Former Member]

Dear Lisa,

I recommend you schedule a "Full Database Backup" and "Transaction Log Backup" via transaction DB13. No other action is required at the SAP, SQL or OS level.

You need to define database backup devices. You can do this via T-SQL in ST04 or via Management Studio. Examples are given in SQL Books Online.

N.P.C