Wednesday, February 15, 2012

export sql db maintenance history

Hi SQL community,
Can someone help me do an export of the MS sql2000 db maintenance history?
ThanksHi
"NigBev" wrote:
> Hi SQL community,
> Can someone help me do an export of the MS sql2000 db maintenance history?
> Thanks
>
You don't say how you want to export the history but some thing like:
BCP "msdb..sysdbmaintplan_history" out maintplan_history.txt -c -S Server -T
may give what you want. Change Server to be the server you wish to export
from.
John

No comments:

Post a Comment