In the event of disaster recovery, the instance where the master database is being restored to should be as close to an exact match to the original as possible. One of the reasons for this is listed in the quote below. See also the Q&A Transfer logins to another server. It is recommended to transfer the SQL Server Logins using the procedure documented by Microsoft. Yes & No The logins would be in the database, but so would other information. Q: If so, then when migrating to another server, if we backup this master db and restore to the new server, then will the logins get migrated to the new server? Q: Are all these stored in the master db? Simply answering your questions is not the solution to your questions.
0 Comments
Leave a Reply. |