MS SQL backup

[Former Member]

Hi,

I really have looked for this, but I cannot seem to find it. I want to do a full database backup of our SQL database, once a week, and I want it to be set up to do this automatically. I can find where to do a full backup, but cannot find where to set this up to do it by itself each week. Can someone help?

Thanks,

Jim

[Former Member]

Thank you all for your help.

[Former Member]

Hi,

If you have professional backup software like Backup Exec, than I recommend using it.

It is always better to have SAP backup included in common backup strategy.

If not : you have two options :

Inside SAP : DB13

Outside SAP : Ms SQL Enterprice Manager

regards,

Wojtek

[Former Member]

Hi,

are you planning to take backup on SQL server is on tape or disk drive?

if you are planning to take backup on disk then check following thread.

Using DB13 tcode you can schedule full online backup weekly.

backup via transaction DB13 is quite simple:

- Call the transaction DB13

- Choose the 'ADD' button of the calendar

- Now you get a popup, where you can select various kinds of jobs via listbox

- Choose the backup you want to execute (e.g. backup to device/backup to TSM)

- Set the backup parameters, e.g. set the device name, choose backup option like 'Online/Offline', 'Including Logs' etc.

- Set the start time

Then add it

you can check backup log using tcode DB12,

regards,

kaushal

Edited by: kaushal malavia on Mar 19, 2008 10:44 AM

[Former Member]

Hi,

You can create a DB Maintainance Plan or you can schedule a Job in SQL Server to take a full Database Backup.

Regards,

Suhas