COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
By default, SQL Server retains backups of many previous logs. Choose the correct answer.
|
|
3
|
|
|
6
|
|
|
9
|
|
|
12
|
Explanation:
Detailed explanation-1: -The default backup directory is C:FilesSQL Server. n, where n is the number of the server instance.
Detailed explanation-2: -Microsoft SQL Server supports five types of backup: full, differential, transaction log, tail log, and copy-only backup.
Detailed explanation-3: -After you configure media retention option, you do not have to specify the length of time to retain system backups each time you perform a backup. The default value is 0 days, and the maximum value is 365 days.
Detailed explanation-4: -A backup of data in a complete database (a database backup), a partial database (a partial backup), or a set of data files or filegroups (a file backup).
There is 1 question to complete.