Câu 7: 70-765: Provisioning SQL Databases
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 namedSQL2008 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 Serve…
Nội dung câu hỏi
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 namedSQL2008 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?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- 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 — đáp án hiện tại
- D. Use xp_logininfo.
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.