cleaning up backup files

• ksexton

  SSCrazy

  Points: 2790

  More actions

  July 24, 2002 at 12:20 pm

  #63177

  Sometimes sql backups are created and they don't have the file extension .BAK

  I am trying to clean up our 20 WIN2K servers of all these llose ends. Any ideas how I can identify sql backup files?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  July 24, 2002 at 1:44 pm

  #433312

  Only way I know is to load each and read the header. Probanly can use DMO to do this.

  Andy?

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones