deletion from backup device

Question

Post reply

deletion from backup device

chen kirsch

SSC-Addicted

Points: 431
More actions
May 22, 2005 at 2:46 am

#167076

hello all.
does any one know if there is a way to delete specific backups from backup devices?? And if so what's the script??
thanks in advance
chen

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

sushila SSC-Dedicated Points: 35293 More actions · Answer 1

Look up sp_dropdevice in BOL...

**ASCII stupid question, get a stupid ANSI !!!**

chen kirsch SSC-Addicted Points: 431 More actions · Answer 2

This SP will delete the entire device.... i only want to delete those who are expired from it to conserve space. Is there a script for it or do i do it progrematiclly??

chen

sushila SSC-Dedicated Points: 35293 More actions · Answer 3

Chen - not sure what you mean when you say "will delete the entire device"! You are going to be specifying name of device to be dropped....alternately, the easier way to do this will be via Enterprise Manager - under the "Management" - "Backup" folder where you can manually select and delete the ones you don't want.

I also came across this site that has a procedure that deletes devices...maybe you could use some/all of it...

http://perso.wanadoo.fr/ngx/doc/sqlbhtml/sybsystemprocs_dbo_sp_dropdevice.html

**ASCII stupid question, get a stupid ANSI !!!**

chen kirsch SSC-Addicted Points: 431 More actions · Answer 4

Sorry for the inclarity, i will try to explain :

in a backup device there are many backups, and i am looking for a script that will delete specific backups from the file without deleting the whole device

if you know any scripts, i would thank you if you post them

thanks

chen

sqlSherwin SSCrazy Points: 2884 More actions · Answer 5

Here is the script that I use

Option Explicit

'on error resume next

Dim oFSO

Dim sDirectoryPath

Dim oFolder

Dim oFileCollection

Dim oFile

Dim iDaysOld

'Customize values here to fit your needs

iDaysOld = 2

Set oFSO = CreateObject("Scripting.FileSystemObject")

sDirectoryPath = "Backup Directory Path"

set oFolder = oFSO.GetFolder(sDirectoryPath)

set oFileCollection = oFolder.Files

'Walk through each file in this folder collection.

'If it is older than 3 weeks (21) days, then delete it.

For each oFile in oFileCollection

If oFile.DateLastModified < (Date() - iDaysOld) Then

oFile.Delete(True)

End If

Set oFSO = Nothing

Set oFolder = Nothing

Set oFileCollection = Nothing

Set oFile = Nothing

chen kirsch SSC-Addicted Points: 431 More actions · Answer 6

Thanks for the reply, but....

i wanted specific files from backup SETS, not stand alone files, and in TSQL, as i know how to do this in vb

thnks chen