SQL Server Performance Forum – Threads Archive

Delete backup file

With the enterprise manager I’ve made several complete backups on a remote server.
Now I need to delete old backups to make more room for new ones.
The problem is that those files appear to be locked, access denied, no opertion can be done (delete, copy, rename..etc). can anybody help me? thanks

---

You can remove backup devices by right-clicking the backup device in the Server Manager and choosing Delete from the menu or by clicking Delete on the Backup/Restore dialog box. They can also be removed using the system procedure
sp_dropdevice logical_name

---

thanks for a quickly answer… I’ve no entry in "managementackup", but I’ve several entries in the logs with "failed backup" when I tried to enter the correct path to remote server before enabling the trace
flags (1087) for remote filesystem backup.

---

]]>