ADSM-L

Re: Is there a way to delete all files that were backed up last

2001-09-19 12:49:46
Subject: Re: Is there a way to delete all files that were backed up last
From: Glen Smith <tsm-l AT ENGINEER DOT COM>
Date: Thu, 20 Sep 2001 00:50:47 +0800
Please consider this fair warning:

I would NOT use "delete object" to remove backups from your system.

Using this command WILL corrupt your database and create massive headaches for 
you down the road.  This is worse than the virus you're trying to remove.

The command isn't documented or supported because it does not behave as you 
might think.  It does not update all the necessary tables to remove an object 
from the system.

You would be better off to use one of the other methods suggested (Doug 
Thorneycroft's for example) to remove the suspect files.

Glen Smith
"Once bitten, twice shy"



        Peter Bjoern <pebjn AT WMDATASDC DOT DK>
                 To: ADSM-L AT VM.MARIST DOT EDU
                 cc:
                 Subject: Re: Is there a way to delete all files that were 
backed up last              night for certain clients



One way might be to get a list of the object_id's with a SQL statement
something like :

select object_id from backups where node_name='MYNODE' and backup_date >
= '2001-09-18 00:00:00.000000'

or some other selection criteria which may select what you want.

Then edit the list to produce a script file that contains a bunch of  the
undocumented delete_object command :

delete_object 0 object_id#

Please be careful that you select only the object_ids you really want to
delete ...

Regards

Peter


--
_______________________________________________
_______________________________________________
Have you downloaded the latest calling software from Net2Phone? Click here to 
get it now!

http://www.net2phone.com/cgi-bin/adforward.cgi?p_key=NH211JK&url=http://commcenter.net2phone.com/



<Prev in Thread] Current Thread [Next in Thread>