MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
SQL Server will not allow you to restore a database backup over an existing database if you have not performed a tail-log backup on the database. If you attempt to do this using SSMS, SQL Server will issue a warning and will automatically attempt to create what, choose the correct answer.
A
a tail-log backup
B
a transaction-log backup
C
a deferential backup
D
None of the above
Explanation: 

Detailed explanation-1: -A tail-log backup captures any log records that have not yet been backed up (the tail of the log) to prevent work loss and to keep the log chain intact. Before you can recover a SQL Server database to its latest point in time, you must back up the tail of its transaction log.

Detailed explanation-2: -If you do not want to risk having errors for an online database, you must use the WITH NORECOVERY option of the BACKUP T-SQL statement. NORECOVERY is an option that backs up the tail of the log and leaves the database in RESTORING state.

Detailed explanation-3: -Step 1: Take a tail log backup Execute the command: BACKUP LOG <database name> TO <backup device> WITH NORECOVERY; This command captures log entries that have not been backed up and puts the database into the RESTORING state so no new data can be added. A normal t-log backup does not use the NORECOVERY option.

There is 1 question to complete.
Previous
Next