You are the systems administrator for your company. The network consists of a Windows Essential Business Server (EBS) 2008 environment. The network contains two instances of SQL Server 2008 named SQL1 and SQL2. You want to move a database named ProdDB from SQL1 to SQL2 by using the Copy Database Wizard.
What is the minimum permission that you will require for this purpose?
A.
membership in the serveradmin fixed server role on both SQL1 and SQL2
B.
membership in the securityadmin fixed server role on both SQL1 and SQL2
C.
membership in the dbcreator fixed server role on both SQL1 and SQL2
D.
membership in the sysadmin fixed server role on both SQL1 and SQL2
Explanation:
You will require membership in the sysadmin fixed server role on both SQLl and SQL2. The Copy Database Wizard allows you to move or copy databases and their objects from one server to another without any server downtime. You can use the Copy Database Wizard to upgrade from a SQL Server 2000 database to a SQL Server 2005 or later database. To use the Copy Database Wizard, you must be a member of the sysadmin fixed server role on both the source and destination servers. Members of the sysadmin fixed server role can perform any activity on the server.All other options are incorrect because to use the Copy Database Wizard you must be a member of the sysadmin fixed server role on both the source and destination servers. The serveradmin fixed server role enables its members to change server-wide configuration options and shut down the server. The securityadmin fixed server role enables its members to manage logins and their properties. The dbcreator fixed server role enables its members to create, alter, drop, and restore any database.