Solved

How to delete scheduled backup.

Posted on 2008-10-28
4
624 Views
Last Modified: 2012-06-21
I am using SQL Server 2000. I have scheduled a backup by right clicking on the db-->Tasks-->Backup database. Now i want to remove the backup which was scheduled by me. How can i do?
0
Comment
Question by:ynaina
  • 2
  • 2
4 Comments
 
LVL 7

Expert Comment

by:wct296
ID: 22828868
Its under maintenance plans

Sorry I don't have access to a SQL 2000 box anymore (all 2005 or 2008) so I can't tell you which menu its under... but i'm sure you'll find it
0
 

Author Comment

by:ynaina
ID: 22828902
I have it under maintenance plan also. Because of that now i am getting two backups every day.
0
 
LVL 7

Accepted Solution

by:
wct296 earned 50 total points
ID: 22828946
Hmmm maybe you scripted it... check under control panel - scheduled tasks... you can start the process via a command script... so maybe its in there (doubt it tho)

Also try a command prompt and type "at" this will display any AT based scheduled tasks
0
 

Author Comment

by:ynaina
ID: 22829141
it is not there in scheduled task.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now