How to delete this data

[villica]

I am in the process of learning sql server. I bought this book "10 projects you can do with microsoft sql server 7".
On the second chapter they show you how do a back up. In the process I think I missed something so I want to star again. This is my problem

If I right clik on the database pubs
All task
Restore database
Another scren comes up with all the back ups I made.


Is there a way to delete all of these so that I start fresh without doing a brand new installation.

Please help me if you can.

thank you kindly
villica


villica

 

[JOHNHN]

In that screen where you see all the backups listed, click on device and then use the browse button to go to the directory where you want to store your backup. Finish the path by typing in a file name that you have chosen. Use the *.bak suffix at the end of your file name. Click okay and return to the main screen. You should see a progress bar start for the backup.

 

[ecobb]

To answer your question, I believe the default directory for backupfiles is C:\Program Files\Microsoft SQL Server\MSSQL\Backup (or whatever drive you installed it on) Unless you specified a different directory to backup the files to, you should be able to look here and find all of your old backups and delete them.

Hope this helps.