cancel
Showing results for 
Search instead for 
Did you mean: 

Backup and Log reduction scheduling in background

former_member203760
Participant
0 Kudos
58

Hi Experts,

We need to schedule backup in weakly and monthly automatically. this is to  replace new backup in weakly and monthly.

Weakly is deferential backup and monthly is full backup. and also we need log reduction automatically when it will reach more than 1GB.

please help me for this.

Thanks in Advance

Thanks

J Jana

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Jana,

Regarding your question about automatically shrinking the log file:

A transaction log backup frees space in the transaction log file. If the transaction log size and the frequency of the transaction log backups fits your system's load profile it's not necessary to shrink the transaction log file on a regular basis.

How often are you taking a transaction log backup?

Regards,

Beate

Akashcm10
Explorer
0 Kudos


You can also use SQL management studio to schedule backups regularly.

former_member184473
Active Contributor
0 Kudos

Hello,

You can schedule this backup jobs under transaction DB13.

Regards,

Eduardo Rezende

former_member203760
Participant
0 Kudos

Hi Resende,

Thanks for your replay.

I don't have idea how to schedule backup in DB13 and i need to do automatic  log reduction  also.

Can you please tel how to do this both.

Thanks

J Jana

former_member184473
Active Contributor
0 Kudos

Hello J Jana,

You just have to select a data/time and select the available actions.

Check the following website for further information:

Setting Up the DBA Planning Calendar (MS SQL Server) (SAP Library - BC R/3 Database Guide: MS SQL Se...

About the log shrink, we don't recommend to run shrinks.

Regards,

Eduardo

former_member203760
Participant
0 Kudos

Hi Rezende,

As per your suggestions i have scheduled in DB13.

But i have doubt where will be save my data base backup and it will done automatically as per my date.

Thanks

J JAna

former_member184473
Active Contributor
0 Kudos

Hello,

Check the logs and you can find where the backup are saved.

You can also setup a "backup device" to a particular location.
Check the following website for further information:

Backup Devices (SQL Server)

Regards,

Eduardo Rezende

former_member203760
Participant
0 Kudos

Hi Rezende,

Thanks for your replay.

Thanks

J Jana