SQL DBA Tutorial

Backup and Restore Interview Question and Answers

Backup and Restore Interview Question and Answers

1. What are the Database recovery models available in SQL Server?

SQL server support 3 types of recovery models.

2. What are the Different types of Backups available in SQL Server?

SQL Server supports different type of backup for database. However, which type of database backup can be performed totally depends upon the recovery model of the database one choose.

3. What are the permissions required to perform Backup and Restore the Database?

Backup: To perform backup the login must be assigned to any of the below roles.

Restore: To perform restore the database the login must be assigned to any of the below roles.

4. What are some common reason why database restores fail?

5. How do you know if your database backups are restorable ?

6. Can we able to take the backup for ‘Resource Database’?

7. How can we rebuild Resource system database? 

8. How can full Backup be issued without interrupting the LSN?

9. Can we perform a tail log backup if MDF file is corrupted?

   YES, We can perform a trail log backup as long as the LDF file if not corrupted. Actually the tail log backup is having 2 options.

  1. With Norecovery.
  2. Continue After Error.

WITH NORECOVERY:  To make sure no transactions happens after the tail log backup.

CONTINUE AFTER ERROR: Just tp make sure log backup happens even though some meta data page corrupted.

10. What are the restore options available in SQL Server?

When you restore a backup, you can choose from 3 restore options.

  1. With Recovery.
  2. With No Recovery.
  3. Standby\ Read only.

11. Is it possible to restore a database backup of SQL Server 2014 to SQL Server 2008\2012?

No it’s not possible to restore the upper version database backup to lower version SQL Server.

 

SQL Server installation interview Questions and Answers

Installation of SQL Server 2019

 

 

 

 

          

Get SQL Dba Tutorial Updates!

Signup now and receive an email once I publish new content.

Thank you for subscribing.
Something went wrong.
I agree to have my personal information transfered to MailChimp ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Exit mobile version