Backup Oddity

A client needed to put in there own backup (without using
the Database Maintence Plan) I won't go into the reasons
but it was correct.
Anyway they asked us to find a safe way of deleting the
internal records and the files, hence me.
I have found something pretty odd. The sp_dropdevice does
not delete the records in the msdb tables backupset or
backupmediafamily why is this the case ?
Thanks
JYou would have to ask the MS programmers that wrote sp_dropdevice why it
doesn't delete the backup history. It might have been a conscious decision,
it might have been that they just didn't do this when backup history tables
changed structure between 6.5 and 7.0. It is always difficult to answer
"why" question if you weren't present MS design. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:ed7d01c40c36$12470cb0$a401280a@.phx.gbl...
> A client needed to put in there own backup (without using
> the Database Maintence Plan) I won't go into the reasons
> but it was correct.
> Anyway they asked us to find a safe way of deleting the
> internal records and the files, hence me.
> I have found something pretty odd. The sp_dropdevice does
> not delete the records in the msdb tables backupset or
> backupmediafamily why is this the case ?
> Thanks
> J|||Thanks Tibor,
Now I don't need to trawl though BOL to see if I have
missed anything :-D
J

>--Original Message--
>You would have to ask the MS programmers that wrote
sp_dropdevice why it
>doesn't delete the backup history. It might have been a
conscious decision,
>it might have been that they just didn't do this when
backup history tables
>changed structure between 6.5 and 7.0. It is always
difficult to answer
>"why" question if you weren't present MS design. :-)
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Julie" <anonymous@.discussions.microsoft.com> wrote in
message
>news:ed7d01c40c36$12470cb0$a401280a@.phx.gbl...
using
does
>
>.
>|||A tip, Julie:
Read the source code for the procedure in question. Reading the source code
for sp_dropdevice, I see that there is no code in there to remove backup
history, so there is no need to look any further. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:ecfd01c40c39$8ee0e8b0$a301280a@.phx.gbl...
> Thanks Tibor,
> Now I don't need to trawl though BOL to see if I have
> missed anything :-D
> J
>
>
> sp_dropdevice why it
> conscious decision,
> backup history tables
> difficult to answer
> message
> using
> does|||Again thanks Tibor,
J

>--Original Message--
>A tip, Julie:
>Read the source code for the procedure in question.
Reading the source code
>for sp_dropdevice, I see that there is no code in there
to remove backup
>history, so there is no need to look any further. :-)
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>
>"Julie" <anonymous@.discussions.microsoft.com> wrote in
message
>news:ecfd01c40c39$8ee0e8b0$a301280a@.phx.gbl...
reasons
the
or
>
>.
>