COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Minimally, you must have created at least one full backup before you can create any log backups. After that, the transaction log can be backed up at any time unless the log is already being backed up. We recommend you take log backups frequently, both to minimize work loss exposure and to truncate the transaction log.
Detailed explanation-2: -A full database backup backs up the whole database. This includes part of the transaction log so that the full database can be recovered after a full database backup is restored.
Detailed explanation-3: -What Is a Transaction Log Backup? Transaction log backup is a backup technique that requires the copy of a transaction log. With it, you can recover the database to any point in time since the last T-log backup. You need to perform a full backup before you can create any T-log backups.
Detailed explanation-4: -If you have not already set up the destination database for log shipping, the wizard can do this for you by taking a full backup of the source database and restoring it to a new or existing database on the secondary SQL Server.
Detailed explanation-5: -If your database is set to the “Full” or “Bulk-logged” recovery model then you will be able to issue “Transaction Log” backups.