You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. You have been informed by the CIO that the msdb database on a SQL Server 2005 computer is corrupted. This database should therefore be restored. A Domain.com employee named Dean Austin is employed as a junior technician in the Finance department. You inform him that the databases should be backed up daily. The backup files of the database are written to a network share. However, the file names do not clearly specify which databases are in every file. Dean Austin needs to locate the right backup file as quick as possible. You inform him that the first file in the list is named DB_Backup.bak.
What Transact-SQL statement should Dean Austin use?
A.
Dean Austin should use the RESTORE DATABASE MSDBFROM DISK = NServer1BackupDB_Backup.bak Transact-SQL statement.
B.
The Transact-SQL statement RESTORE LABELONLYFROM DISK = NServer1BackupDB_Backup.bak should be used.
C.
Dean Austin should use the RESTORE VERIFYONLYFROM DISK = NServer1BackupDB_Backup.bak Transact-SQL statement.
D.
Dean Austin should use the RESTORE HEADERONLYFROM DISK = NServer1BackupDB_Backup.bak Transact-SQL statement.