|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How can I cancel a backup?I'm running SBS 2003 Premium. I've got several databases set up to be backed
up nightly, but I have deleted one of them since I set up the backup jobs. Unfortunately, even though the database is deleted, it still tries to back it iup each night and I get an error in the "Monitoring and Reporting" page in Server Management. I set up the backups through SQL server. I can't seem to find where the backups jobs are "stored." I looked at Scheduled Tasks, the registry, and in Enterprise Manager under Maintenance Plans and under Management -> Backup. The backups were not set with Maintenance Plans, they were set by right clicking on the individual databases and selecting "Backup Database." How do I cancel the backup? Thank you in advance. Jon EM, Management, SQL Server Agent, Jobs.
-- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ http://www.sqlug.se/ "Jonathan R. Karp" <JonathanRK***@discussions.microsoft.com> wrote in message news:8FBB877F-E6FF-47F4-8900-FEFBD92E0653@microsoft.com... > I'm running SBS 2003 Premium. I've got several databases set up to be backed > up nightly, but I have deleted one of them since I set up the backup jobs. > Unfortunately, even though the database is deleted, it still tries to back it > iup each night and I get an error in the "Monitoring and Reporting" page in > Server Management. > > I set up the backups through SQL server. I can't seem to find where the > backups jobs are "stored." I looked at Scheduled Tasks, the registry, and > in Enterprise Manager under Maintenance Plans and under Management -> Backup. > > The backups were not set with Maintenance Plans, they were set by right > clicking on the individual databases and selecting "Backup Database." > > How do I cancel the backup? > > Thank you in advance. > > Jon > That worked! Thank you very much!
Jon Show quote "Tibor Karaszi" wrote: > EM, Management, SQL Server Agent, Jobs. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > http://www.sqlug.se/ > > > "Jonathan R. Karp" <JonathanRK***@discussions.microsoft.com> wrote in message > news:8FBB877F-E6FF-47F4-8900-FEFBD92E0653@microsoft.com... > > I'm running SBS 2003 Premium. I've got several databases set up to be backed > > up nightly, but I have deleted one of them since I set up the backup jobs. > > Unfortunately, even though the database is deleted, it still tries to back it > > iup each night and I get an error in the "Monitoring and Reporting" page in > > Server Management. > > > > I set up the backups through SQL server. I can't seem to find where the > > backups jobs are "stored." I looked at Scheduled Tasks, the registry, and > > in Enterprise Manager under Maintenance Plans and under Management -> Backup. > > > > The backups were not set with Maintenance Plans, they were set by right > > clicking on the individual databases and selecting "Backup Database." > > > > How do I cancel the backup? > > > > Thank you in advance. > > > > Jon > > > > > |
|||||||||||||||||||||||