MSDB Backup History Cleanup

From: Dave Brooks (dbrooks_at_neca.org)
Date: 09/08/03 

Date: Mon, 08 Sep 2003 12:36:59 -0700

After successful deletion of about 2 years of history data, is there any
maintenance that should be done to the msdb database itself to recover
the space, please advise!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: MSDB Backup History Cleanup
    ... You can use DBCC SHRINKFILE to reduce the size of a data ... >maintenance that should be done to the msdb database itself to recover ...
    (microsoft.public.sqlserver.security)
  • Re: cant open document
    ... least recover portions. ... maintenance, including the suggestions re OS X maintenance under Repair Disk ... > occassionally opening and closing the document, saving often!, opening ... > and closing other docs to copy text from, ...
    (microsoft.public.mac.office.word)
  • Re: no peformance and maintenance
    ... > recover this? ... If you still do not have "performance and maintenance" after following ... Michael's advice, look for a link in the top left hand corner of the ...
    (microsoft.public.windowsxp.accessibility)
  • Re: Cannot start SQL 2000
    ... If you have some SQL jobs, you can either script them out before uninstalling 2000 or backup and recover the msdb database like the master. ...
    (microsoft.public.sqlserver.server)
  • Recover DTS
    ... How can I recover a DTS without recover a old msdb database over current msdb? ... Prev by Date: ...
    (microsoft.public.sqlserver.dts)
Quantcast