You administer a Windows Essential Business Server (EBS) 2008 environment. The network contains an instance of SQL Server 2005 that contains a database named Products. You have configured full, differential, transaction log, and snapshot backups for the Products database. You install a new SQL Server 2008 instance. You want to detach the Products database from SQL Server 2005 and attach it to SQL Server 2008.
What should you do first to accomplish this?
A.
Delete all snapshots of the Products database.
B.
Configure the Products database as read-only.
C.
Restart the SQL Server 2005 instance in single-user mode.
D.
Restart the SQL Server 2008 instance in single-user mode.
Explanation:
You should first delete all snapshots of the Products database. You can detach the data and transaction log files from an instance of SQL Server and then reattach them to the same instance or another instance of SQL Server. When you detach a database, it is removed from the instance of SQL Server, but it remains intact within its data and transaction log files. You can use the detached data and transaction log files to attach the database to any instance of SQL Server. You cannot detach a database if any of the following conditions is true:* The database is replicated and published. If the database is replicated, it must be unpublished.
* A database snapshot exists on the database. A database snapshot cannot be detached or attached. Therefore, before you can detach the database, you must drop all snapshots of the database.
* The database is being mirrored in a database mirroring session.
* The database is suspect.
* The database is a system database.You should not configure the Products database as read-only because this will not allow you to detach the database until you drop all snapshots of the database. Also, it is not necessary to configure a database as read-only to detach it. Configuring a database as read-only is useful when you want to enable users to access a database but prevent them from making any changes to the database.
You should not restart the SQL Server 2005 or SQL Server 2008 instance in single-user mode because this will not allow you to detach the database until you drop all snapshots of the database. Starting an instance of SQL Server in single-user mode is useful when you want to troubleshoot the instance or databases stored on the instance. Also, it is not necessary to restart an instance of SQL Server in single-user mode to detach a database from that instance.