I've setup log shipping between two servers (they used to be mirrored).

What is the simplest or most efficient way to mirror the system databases between the primary and secondary?

  • Is it just a matter of backing these databases on the Primary and then restoring them on the Secondary?

Further, does anyone know of a TSQL script or a (free) program that'll script all logins from the primary server?

  • 1
    Is this a one time thing or do you need to keep them in sync? For the logins, try this script from Robert Davis. sqlsoldier.com/wp/sqlserver/… Jun 26 '16 at 19:03
  • I'll check out the script, thank you! The system database migration might happen more than once depending on what management decides. Jun 26 '16 at 19:29

System databases cannot be mirrored or logshipping.

The best way is to script and sync up desired objects e.g. logins, jobs, etc.

The best tool that I have used so far for migrating databases, jobs, agent schedules, operators, logins, etc is powershell based dbatools.io

  • I should've mentioned that I realized that you can't log ship or mirror system databases. It was a direct question of how to script them, if you will, and you answered that with your link. Thank you, Kin! Jun 27 '16 at 2:23

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.