Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Cancel backup procedure

Posted on 2004-11-24
5
Medium Priority
?
319 Views
Last Modified: 2008-03-06
Hi

I wan to cancel backp proocedure in SQL 2000

I have created a database and then i have clicked on Tools / backup database
I have selected the db and specified the folder to where backup should be saved

Now i want to cancel this procedure, i don't need the backup anymore
so i clicked on tools / backup database but i don't see any option or link to disable backup for this database

Any tip is welcome
0
Comment
Question by:humer2000
  • 3
  • 2
5 Comments
 
LVL 16

Accepted Solution

by:
muzzy2003 earned 1500 total points
ID: 12664200
There's nothing to cancel - this just does a one-off backup of your database.

If you don't want the backup file this created, then just delete it.
0
 
LVL 1

Author Comment

by:humer2000
ID: 12664270
right
thx anyway
0
 
LVL 16

Expert Comment

by:muzzy2003
ID: 12664293
How does this only qualify for a B? Just because you don't like the answer ...

;)
0
 
LVL 1

Author Comment

by:humer2000
ID: 12664347
sorry, i give A only for tecnical answers :))
0
 
LVL 16

Expert Comment

by:muzzy2003
ID: 12664359
Sounded pretty technical to me. :)

If you want a scheduled backup, by the way, the simplest way is to set up a new database maintenance plan. When you have made one of these, it will appear in Enterprise Manager under Database Maintenance Plans, from where you can delete it. Just in case you need it in the future.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

577 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