Log Shipping Interview Questions

Log Shipping interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. Which of the following is the instance of SQL Server that is your production server in log shipping ?

A. secondary database

B. primary database

C. secondary server

D. primary server

Correct Answer is : primary server

2. Point out the correct statement :

A. The restore job can be delayed until all users disconnect themselves

B. Log shipping cannot be combined with other disaster recovery options such as AlwaysOn Availability Groups

C. SQL Server log shipping has high cost in human

D. None of the mentioned

Correct Answer is : The restore job can be delayed until all users disconnect themselves

3. In which of the following modes, the database is read-only ?

A. Stand by

B. Read only

C. Restore mode

D. All of the mentioned

Correct Answer is : Stand by

4. Point out the wrong statement :

A. The principal database in a mirroring session can also act as the primary database in a log shipping

B. Log Shipping is comparatively tougher than database mirroring for setup

C. The database log shipping setup needs to be initiated from the principal server using the SQL Server Management Studio wizard

D. A given database can be mirrored or log shipped; it can also be simultaneously mirrored and log shipped

Correct Answer is : Log Shipping is comparatively tougher than database mirroring for setup

5. Which of the following stored procedure is used to add a primary database on primary server ?

A. sp_add_log_shipping_primary_database

B. sp_add_primary_database

C. sp_add_log_shipping

D. sp_add_log_shipping_primary

Correct Answer is : sp_add_log_shipping_primary_database

Log Shipping interview questions