What T-SQL commands are used to create and remove database snapshots respectively?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB. You want to get yourself acquainted with
Database snapshots.
What T-SQL commands are used to create and remove database snapshots respectively?
Choose all that apply.

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB. You want to get yourself acquainted with
Database snapshots.
What T-SQL commands are used to create and remove database snapshots respectively?
Choose all that apply.

A.
UPDATE.

B.
CREATE SNAPSHOT

C.
DELETE SNAPSHOT

D.
DROP DATABASE

E.
REMOVE DATABASE

F.
DELETE DATABASE

G.
INSERT ANY DATASPACE.

H.
RECREATE.

I.
CREATE DATABASE

J.
REMOVE SNAPSHOT
K.
DROP SNAPSHOT

Explanation:

Microsoft SQL Server Database Administrators has a new feature with the Microsoft SQL Server
2005 Edition which is database snapshots.
A snapshot can persists until it is dropped using DROP DATABASE command.
Also multiple snapshots can be created with different names of a database called as source
database.
In order to create a MS SQL Server database snapshot, CREATE DATABASE statement is used.



Leave a Reply 0

Your email address will not be published. Required fields are marked *