locked
Transport databases to a different physical server/instance, script out all logins, server permissions and roles or simply restore MASTER DB RRS feed

  • Question

  • hi folks:

      I understand that MSFT has a doc to show how to transport logins , also plenty of references introducing Powershell to transport logins, server level permissions and roles.... 

     I  am wondering if  restoring MASTER DB could be good enough? ?  Using SQLCMD for sure.

    Thanks

    Hui


    --Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

    Friday, October 13, 2017 6:08 PM

All replies

  • Hi Hui,

    Per your scenario, you want to transport system-level information by restoring Master DB. Based on this, if the version of your SQL Server is above SQL Server 2016, the feature is available. For more information, please refer to Restore the master Database.

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, October 16, 2017 8:09 AM