Question: 20
You maintain a SQL Server 2008 Enterprise Edition instance that contains a database named Finance. You need to reduce the size of the full database backup files of the Finance database. Which Transact-SQL statement should you use
A. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak';
B. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH COMPRESSION;
C. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH DIFFERENTIAL;
D. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH COMPRESSION, DIFFERENTIAL;
Answer: B
No comments:
Post a Comment
Note: only a member of this blog may post a comment.