PrepAway - Latest Free Exam Questions & Answers

You administer a Microsoft SQL Server 2012 instance named SQL2012. You are in the process of migrating a datab

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

?

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