Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Practice Questions—Backup Strategies
Test your knowledge about SQL Server's backup process.
Michael D. Reilly
September 11, 2000
1 Min Read
1. Suppose you have a very large database to back up and the nightly full backups to tape are threatening to exceed your backup window and spill over into working hours. Which of the following strategies could you use to speed up the backups? Select all correct answers.
Perform a full backup on the weekend and differential backups during the week.
Perform a full backup on the weekend, and during the week, back up only the tables with many changes.
Perform a full backup on the weekend and filegroup backups during the week.
Back up to disk files instead of to tape, then use the Windows NT or other backup software to move the backup files to tape.
2. Which of the following strategies can speed up a database backup? Select all correct answers.
Back up to multiple devices by using SQL Server's striping capability.
Back up to an NT striped disk set, built by using RAID 5 in your software.
Put the database data files on a RAID array.
Spread the transaction log across multiple files on separate disks.
3. Which of the following devices can you use for a SQL Server backup? Select all correct answers.
Local hard disk
Remote hard disk
Local tape drive
Remote tape drive
DVD-RAM drive
CD-RW (read-write erasable) drive
ZIP drive
JAZ drive
4. You try to back up the transaction log for a database, but the option to back up the log isn't available in Enterprise Manager. What could be the problem? Select all correct answers.
The transaction log has no entries because no one is working on the database.
You haven't run a full backup yet.
The database has the truncate log on checkpoint option set.
No devices are defined for the log backup.
You've recently performed a nonlogged operation.
You've performed a differential backup since the last full backup.
About the Author
You May Also Like
