Home All Groups Group Topic Archive Search About

How can I cancel a backup?

Author
17 Mar 2005 5:01 PM
Jonathan R. Karp
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

Author
17 Mar 2005 5:09 PM
Tibor Karaszi
EM, Management, SQL Server Agent, Jobs.

Show quote
"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
>
Author
17 Mar 2005 6:17 PM
Jonathan R. Karp
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
> >
>
>
>

AddThis Social Bookmark Button