Saturday, February 25, 2012

msdb restore to standby server

Can the msdb database safely be moved to a new server by taking a backup fro
m
the source server and restoring to the target? I am aware that
sysjobs.originating_server must be updated after the restore and that
Microsoft suggests transfering the msdb by scripting jobs, dts packages, etc
.SQL Server 2000 sp3
"Brandon" wrote:

> Can the msdb database safely be moved to a new server by taking a backup f
rom
> the source server and restoring to the target? I am aware that
> sysjobs.originating_server must be updated after the restore and that
> Microsoft suggests transfering the msdb by scripting jobs, dts packages, e
tc.
>|||Ive never had good luck doing that and just would up going the MS route.
--
TIA,
ChrisR
"Brandon" wrote:

> Can the msdb database safely be moved to a new server by taking a backup f
rom
> the source server and restoring to the target? I am aware that
> sysjobs.originating_server must be updated after the restore and that
> Microsoft suggests transfering the msdb by scripting jobs, dts packages, e
tc.
>

No comments:

Post a Comment