You are the systems administrator for your company. You install Windows Essential Business Server 2008 Premium Edition on the network, which contains a SQL Server 2008 computer named SQL1.

You create a new database named Marketing on SQL1. The Marketing database contains two files in a single filegroup, named MktgFGrouplfilel and MktgFGrouplfile2.
You want to back up the two files by using the BACKUP DATABASE Transact-SQL statement.

Which of the following Transact-SQL statements includes the minimum required parameters?

A.
BACKUP DATABASE Marketing
FILE = ‘MktgFGrouplfilel’,
FILE = ‘MktgFgrouplfile2’
TO DISK = ‘D:SQL BackupsMarketingMarketingGrpl.bck’
GO

B.
BACKUP DATABASE Marketing
FILE = ‘MktgFGrouplfilel’, ‘MktgFgroup2file2’,
TO DISK = ‘D:SQL BackupsMarketingMarketingGrpl.bck’
GO

C.
BACKUP DATABASE Marketing
FILE = ‘MktgFGrouplfilel’, ‘MktgFgroup2file2’,
TO DISK = ‘D:SQL BackupsMarketingMarketingGrpl.bck’
GO
WITH
FULL,
GO

D.
BACKUP DATABASE Marketing FILE = ‘MktgFGrouplfilel’, FILE = ‘MktgFgroup2file2’
TO DISK = ‘D:SQL BackupsMarketingMarketingGrpl.bck’
GO
WITH
DIFFERENTIAL,
GO

Explanation:
You should run the following Transact-SQL statement:

BACKUP DATABASE Marketing
FILE = ‘MktgFGrouplfilel’,
FILE = ‘MktgFgrouplfile2’
TO DISK = ‘D:SQL BackupsMarketingMarketingGrpl.bck’
GO
You can create file backups when it is not practical to back up a full database due to database size and performance requirements. A file backup contains all the data in one or more files or filegroups. You should use a BACKUP DATABASE <file_or_filegroup> statement to create a file or filegroup backup. The minimum parameters that are required with this statement are:
The database name
A FILE or FILEGROUP clause for each file or filegroup, respectively
The backup device on which the full backup will be written
You should not run the following Transact-SQL statement:
BACKUP DATABASE Marketing
FILE = ‘MktgFGrouplfilel’, ‘MktgFgroup2file2’,
TO DISK = ‘D:SQL BackupsMarketingMarketingGrpl.bck’ GO
You must specify a separate FILE or FILEGROUP clause for each file or filegroup in the BACKUP DATABASE statement.
You should not run the following Transact-SQL statement:
BACKUP DATABASE Marketing
FILE = ‘MktgFGrouplfilel’, ‘MktgFgroup2file2’,
TO DISK = ‘D:SQL BackupsMarketingMarketingGrpl.bck’
GO
WITH
FULL,
GO
Specifying the backup type is not a required parameter for the BACKUP DATABASE statement. Using the WITH clause to specify the backup type is optional. While backing up files and filegroups, you can specify full or differential backup types.
You should not run the following Transact-SQL statement:
BACKUP DATABASE Marketing
FILE = ‘MktgFGrouplfilel’,
FILE = ‘MktgFgroup2file2’
TO DISK = ‘D:SQL BackupsMarketingMarketingGrpl.bck’
GO
WITH
DIFFERENTIAL,
GO
Specifying the backup type is not a required parameter for the BACKUP DATABASE statement. Using the WITH clause to specify the backup type is optional.