itgle.com
YoudiscoverthatthemsdbdatabaseonaSQLServer2005computeriscorruptandmustberestored.Databasesarebackedupdaily.Thedatabasebackupfilesarewrittentoanetworkshare，butthefilenamesdonotclearlyindicatewhichdatabasesareineachfile.Youneedtolocatethecorrectbackupfileas
题目
YoudiscoverthatthemsdbdatabaseonaSQLServer2005computeriscorruptandmustberestored.Databasesarebackedupdaily.Thedatabasebackupfilesarewrittentoanetworkshare，butthefilenamesdonotclearlyindicatewhichdatabasesareineachfile.Youneedtolocatethecorrectbackupfileasquicklyaspossible.ThefirstfileinthelistisnamedDBBackup.bak.WhichTransact-SQLstatementshouldyouuse？（）
A.RESTORELABELONLYFROMDISK=N\\Server1\Backup\DBBackup.bak
B.RESTOREHEADERONLYFROMDISK=N\\Server1\Backup\DBBackup.bak
C.RESTOREVERIFYONLYFROMDISK=N\\Server1\Backup\DBBackup.bak
D.RESTOREDATABASEMSDBFROMDISK=N\\Server1\Backup\DBBackup.bak
相似考题
参考答案和解析
参考答案：B