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

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

export sql db maintenance history

Hi SQL community,
Can someone help me do an export of the MS sql2000 db maintenance history?
Thanks
Hi
"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