移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 Enterprise Edition instance. There is a database named DB1 in the instance. A backup of DB1 is performed every day. You have to minimize the size of the full database backup files of DB1.  In the options below, which Transact-SQL statement should you use? ()  

发布日期:2021-03-17

You work in a company which uses SQL Server 2008. ...
A

BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak';

B

BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH COMPRESSION;

C

BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH DIFFERENTIAL;

D

BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH COMPRESSION,DIFFERENTIAL;

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!