Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sgriesel
Starting Member
1 Post |
 Posted - 2012-01-11 : 05:15:02
|
| Hey guys!! I need some help on maintenance plans and scheduling a backup. I created a new maintenance plans which creates a FULL BACKUP and LOG backup of my database on a Monday then another maintenance plans for Tues-Fri to only do DIFFERENTIAL BACKUP and LOGS. The plans have been successfully created and scheduled but not running? Any specific reason it is not? Am I missing something?Looking forward to your replies :)ThanksStephan |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-01-11 : 06:20:38
|
| What does the error log say ?After Monday and Tuesday even the calendar says W T F .... |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2012-01-11 : 06:27:53
|
| Is SQL Agent Service running? |
|
|
|
biswajitdas
Starting Member
44 Posts |
Posted - 2012-01-12 : 12:23:09
|
| 1)Check the SQL agent and permission 2) The maintenance plan requires the Integration Services to be installed.If you did not install , then install it , and re-create the maint-planSr Sql server DBA/Artitech |
|
|
|
|
|
|
maintenance plans & backup