2

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?

2
  • 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, 2016 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.
    – AKDiscer
    Jun 26, 2016 at 19:29

1 Answer 1

1

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

1
  • 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!
    – AKDiscer
    Jun 27, 2016 at 2:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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