0

I am planning for sql server 2019 migration to new hardware.

For the server level logins, roles I can either restore the master db or script these out.

Similarly, for sql agent jobs I can either restore the msdb db or script these out.

When migrating SQL server (same version) to new hardware, are both options feasible? (that is restore of msdb vs scripting)?

2 Answers 2

1

When migrating SQL server (same version) to new hardware, what are both options feasible? (that is restore of master/msdb or scripting)?

As already stated on one of your questions, if the version and CU level remain "exactly" same there would be no problem in restoring system databases. I would prefer restore than scripting out.

0

DBA TOOLS!

https://dbatools.io/commands/ (specifically those under Migration)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.