How to automate full online SQL to tape/device (daily)

[Former Member]

Dear all,

In my company, daily backups is of 2 types.

1. from Db13 SAP level backup full online to tape.

2. from SQL , full online to disk.

Db13 jobs we schedule in SAP.

But, i want to automate the SQL level full online backup to device.(External USB drive)

how to do that, if any SQL script is avaliable means, please let me know that.

thanks in advance,

by

raghav

[Former Member]

Hello Raghav ,

Make sure your SQL Service Agent should be up and running to execute the the job as described by Kevin .

Regads ,

Santosh

[Former Member]

Why are you doing two full online backups in one day?

The DB13 and SQL backups are the SAP thing. All SAP is doing is calling a stored procedure in SQL. SAP can not backup itself directly.

Just right click on the DB say backup, type of backup, set the time and place, click schedule, set the days of the work. Its that simple. You could even do it using the wizard if you wanted to.

[Former Member]

Hello Kevin,

I want to do it from OS level (windows).

where we can create a batch file and schedule tht daily.

so, tht back up will happen to tape drive by the batch file.

i had problem in creating a batch file.

i heard tht batch file can be reated in such a way tht it will execute the same steps

that as we do it by clicking the mouse.

i.e Start>programms>ms sql > enterprise manager > and steps to navigate in enterprise manager.

if we happend to create a batch file like this.. we can schedule that from windows level.

and one more doubt:-

How to restore the BACKUP obtained from DB13 (sap level)?

how good it is when compared to SQL enterprise manager backup ?

hope you give wings to my tought.

thanking you in anticipation.

by

raghavendra rao.

[Former Member]

Your 'batch' file would have to run a SQL script (need SQL agent running). Test it via SQL query then just call it like any other batch file.

DB13 and Enterprise manager will use the SAME stored procedure. they are the same however you run it.

How would you restore a backup scheduled in DB13? via SQL Enterprise Manager like you would with a backup taken from with SQL or via a command prompt.

Don't forget you MUST schedule the log backups via SQL Enterprise Manager - you cant do it via SAP.

Best way is using SQL enterprise manger, else purchase a 3rd party product.