多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

You discover that the ms db database on a SQL Server 2005 computer is corrupt and must be restored. Databases are backed up daily. The database backup files are written to a network share, but the file names do not clearly indicate which databases are in each file. You need to locate the correct backup file as quickly as possible. The first file in the list isnamed DB Backup.bak. Which Transact-SQL statement should you use?()

  • A、RESTORE LABELONLYFROM DISK = N//Server1/Backup/DB Backup.bak
  • B、RESTORE HEADERONLYFROM DISK = N//Server1/Backup/DB Backup.bak
  • C、RESTORE VERIFYONLYFROM DISK = N//Server1/Backup/DB Backup.bak
  • D、RESTORE DATABASE MSDBFROM DISK =N//Server1/Backup/DB Backup.bak
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题