You intend to use SQL Server 2008 instance to create a solution. You create a new database. In the database, a table is used to store Microsoft Office documents. You require that the snapshots of the database are used and the documents are part of the database backup. The documents have to be stored by using an suitable data type. So which data type should you use?
A.
varchar(max)
B.
varbinary(max)
C.
nvarchar(max)
D.
varbinary(max) by using the FILESTREAM attribute
Explanation:
SQL Server does not support database snapshots for FILESTREAM filegroups. If a FILESTREAM filegroup is included in a CREATE DATABASE ON clause, the statement will fail and an error will be raised.