on 05-13-2014 8:37 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can also use SQL management studio to schedule backups regularly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
You can schedule this backup jobs under transaction DB13.
Regards,
Eduardo Rezende
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello J Jana,
You just have to select a data/time and select the available actions.
Check the following website for further information:
About the log shrink, we don't recommend to run shrinks.
Regards,
Eduardo
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:
Regards,
Eduardo Rezende
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.