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.


Leave a Reply