how to find the datafile size used and the retention period for a mainteence plan

• Harris-358031

  Old Hand

  Points: 362

  More actions

  October 24, 2006 at 5:53 am

  #75081

  how to find the datafile size used and the retention period for a mainteence plan from the query analyzer.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  October 27, 2006 at 9:38 am

  #668541

  Use SP_HELPFILE to find file size and RESTORE HEADERONLY to find expiration data of a backup set.

  gREG

  Greg