Remove all Backup Disk Destination after a succesful backup operation on SQL Server 2005 Management Studio

Question

Hi everybody,

I just did a Backup for a Database using SQL Server Management Studio. I did the operation clicking with the right button on the DB Name, selecting Task, then Backup. Then i moved the chek button in the "Backup To" section to disk and i wrote my Destination address.A

After the backup was complete i tried to remove the destination i added but, when i try to click on OK, an error come out saying that i did not sepcified the destination address for my back-up. This is probably because when i click on Ok Management Studio try do to the backup but there are no destination specified. So, what i want to do is have an empty list of destination. Is there a special way to remove all the destination? I searched almost everywhere, also with T-SQL command but apparently there are no solution.

Thanks in advance

Answer 1

Hello,

I'm not sure I understand your question. After the backup completes there is no reason to really "remove" the address as it's not changing anything. This is purely inside of SQL Server Management Studio and is not saved within SQL Server. It's only applicable when the window is used to backup a database, and then you can remove it and add a new destination should you not want to use the same.

-Sean

Answer 2

I want to remove all of the backup destination because what we did is kinda of sneaking operation and i do not want to left trace of my backup. This is the reason why i want to remove everything from the backup window.

Answer 3

Hello,

What you are referencing is ONLY within Management Studio where ever you ran it from.

If you want to cover your tracks you'll have to delete the backupset history in MSDB...

-Sean

Answer 4

Where can i delete the backupset history in Management Studio?

Thanks in advance for your suggestions and patience!

Answer 5

The backup and restore history is stored inside of MSDB in SQL Server, Management Studio is just an application that we use to connect to SQL Server.

There is a pretty good write up about it here: http://www.mssqltips.com/sqlservertip/1727/purging-msdb-backup-and-restore-history-from-sql-server/

-Sean