SQL Server Performance Forum – Threads Archive
use restore msdb on new database server
Dear all: after I checked some posts here regarding move sql from normal to cluster environment,everyone seems prefer using other methods other than just move msdb from old server to new server. But actually I found it’s much faster and convenient to restore msdb to new server to move all the jobs, maintenance plans, dts packages, operators. Can anyone tell me any disadvantages that it may bring?
Thanks heaps in advance!
]]>