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 |
|
vdavid70
Yak Posting Veteran
67 Posts |
 Posted - 2005-10-11 : 05:12:17
|
| I have got a big problem. I have setup a database backup routine to run for everyday of the week except saturdays and sundays. I have come in this morning to find out that the database backup did not happen yesterday(monday) instead happened on sunday. Checked the error logs and backup history there was no errors, there wasn't even anything to specify that the backup was supposed to run yesterday but failed, i mean nothing to tell me why the backup did not run or even an error message to specify something wrong. where else can i look for information on why this backup did not run and any error message to tell me what happened. |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-11 : 05:41:28
|
| "I have setup a database backup routine "Using Maintenance Plan Wizard?"nothing to tell me why the backup did not run"Did it think yesterday was the weekend? Clock wrong on the server? </WildGuess!>Kristen |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-10-11 : 12:59:42
|
| Check your list of Jobs. In Enterprise Manager you can go to Management/SQL Server Agent, then right-click on the job. In each job there is a history of the success/failure and additional details for each step.---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
Backing up