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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-08 : 08:22:46
|
| Janice writes "I have a db that has a maintenance plan that runs a daily backup. The same db also has a backup scenario configured under dbname | All Tasks | Backup Database. The server (windows 2003, sql 2000) is configured for nightly off-site backups using a 3rd party utility. I need to permanently stop the All Tasks | Backup and cannot figure out how to do that. Any help would be appreciated as the .bak file is getting very large.Thanks." |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-08 : 09:24:01
|
| When the Backup was scheduled it will have created a "Job". Disable, or delete, the job:Enterprise manager: Management : SQL Server Agent : Jobs : Right click the jobUser Properties to see the STEPS for the job (e.g. if the job name is not obvious). Or use the Date/Time of the backup file and the "Last Run Date" in the jobs list to narrow it downKristen |
 |
|
|
|
|
|
Cancel backup set