| |

VerySource

 Forgot password?
 Register
Search
View: 781|Reply: 3

Will the two database maintenance plans conflict?

[Copy link]

1

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

Post time: 2020-3-11 00:00:02
| Show all posts |Read mode
I made two database maintenance plans (backing up the same database), one plan was backed up every hour and deleted 6 hours ago; one plan was backed up every day and deleted three days ago.
    But I found that I got the backup data for the last 6 hours (N plans were planned for this time). I wonder if the first plan affected the second plan?
Reply

Use magic Report

0

Threads

3

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-6-4 11:00:01
| Show all posts
Do not back up the two backup plans into the same directory~~If it will affect each other~
Reply

Use magic Report

0

Threads

114

Posts

69.00

Credits

Newbie

Rank: 1

Credits
69.00

 China

Post time: 2020-6-4 18:30:01
| Show all posts
I made two database maintenance plans (backing up the same database), one plan is to backup every hour and delete it 6 hours ago; one plan is to backup every day and delete three days ago
LZ like this, in fact, your second plan is useless, so there is only the first result, because only the last 6 hours of data are stored in the database.
Reply

Use magic Report

1

Threads

2

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

 Author| Post time: 2020-6-5 15:45:02
| Show all posts
TO我是杀人狂
The backup plan I made for another database is an hourly backup to save the data of the last week! The results are saved.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list