PrepAway - Latest Free Exam Questions & Answers

You need to migrate the SQL Server logins from the SQL2…

You administer a Microsoft SQL Server 2012 instance named SQL2012. You are in the process of migrating a
database from a SQL Server 2008 instance named SQL2008 to the SQL2012 instance.
You have upgraded a database from the SQL2008 instance by using the side-by-side migration technique.
You need to migrate the SQL Server logins from the SQL2008 instance to the SQL2012 instance.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Back up the master database on the SQL2008 instance. Restore the master database on the SQL2012
instance

B.
Use the Transfer Logins task in a Microsoft SQL Server Integrated Services package

C.
Use sp_grantlogin

D.
Use xp_logininfo.

Explanation:
sp_grantlogin creates a SQL Server login.
Incorrect Answers:
D: xp_logininfo returns information about Windows users and Windows groups.
https://technet.microsoft.com/en-us/library/ms173449(v=sql.110).aspx

3 Comments on “You need to migrate the SQL Server logins from the SQL2…


Leave a Reply