Remove all Backup Disk Destination after a succesful backup operation on SQL Server 2005 Management Studio
viernes, 13 de abril de 2012 10:26
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
Todas las respuestas
viernes, 13 de abril de 2012 15:29Usuario que responde
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.
viernes, 13 de abril de 2012 15:48I 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.
viernes, 13 de abril de 2012 15:54Usuario que responde
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...
viernes, 13 de abril de 2012 15:56
Where can i delete the backupset history in Management Studio?
Thanks in advance for your suggestions and patience!
viernes, 13 de abril de 2012 16:51Usuario que responde
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/
- Marcado como respuesta Maggie LuoMicrosoft Contingent Staff, Moderator jueves, 26 de abril de 2012 6:07