Top 100+ Log Shipping Interview Questions And Answers
Question 1. Which Edition Support Log Shipping?
Answer :
SQL Server 2005 – Enterprise, Standard, and Workgroup
SQL Server 2008 - Enterprise, Standard, Web, and Workgroup
SQL Server 2008 R2 - Datacenter, Enterprise, Standard, Web, and Workgroup
SQL Server 2012 - Enterprise, Business Intelligence, Standard, and Web
Question 2. Who Can Setup Log Shipping?
Answer :
Members of Sysadmin fixed server function
Database gadget ideas Interview Questions
Question 3. Required Recovery Models In Log Shopping?
Answer :
Full or Bulk logged Recovery Model
Question four. Which Jobs Are Created In Log Shipping?
Answer :
On Primary server – Backup activity
On Secondary Sever – Copy, Restore and Alert Jobs
Database gadget ideas Tutorial
Question five. Whether Log Shipping Supports Automatic Failover?
Answer :
No, it help only manual failover.
IDMS (Integrated Database Management System) Interview Questions
Question 6. Login Can Be Transferred Through Manual Failover?
Answer :
No, you have to create logins and users on secondary server.
Question 7. Types Of Secondary Server?
Answer :
Restoring Mode and Stand by means of mode
Structured Query Report (SQR) Interview Questions
Question eight. Difference Between Restoring Mode And Stand By Mode In Log Shopping?
Answer :
Restoring mode – Database is in restoring mode. You can not access the database.
Stand by means of mode – Database is in read-only node. You can pick the statistics from the database. This database may be used for reporting purpose.
Question 9. What Are The Benefits Of Log Shipping?
Answer :
Easy to setup/configure
Easy to maintain
Easy to failover
Can have a couple of secondary servers
Can be configure with mirroring or replication.
SQL Server Replication Interview Questions
Question 10. What Are The Drawbacks Of Log Shipping ?
Answer :
Need to manipulate each database one at a time
Does not support automatic failover.
Logins can't be moved robotically
Question 11. Which System Database Store Log Shipping Related Information?
Answer :
Msdb
Sql Server Dba Interview Questions
Question 12. What Is The Difference Between Log Shipping 2000 And 2005?
Answer :
Log shipping 2005 makes use of link Server to communicate among Primary, Monitor, and Secondary Servers.
For 2000, Check connectivity of Primary, Monitor, and Secondary Servers.
Please observe, usually take a look at remote connections are enabled on all servers.
Database machine standards Interview Questions
Question 13. How To Monitor Log Shipping?
Answer :
Reports- Transaction log delivery widespread report
3rd birthday celebration device
SQL Server System tables and stored strategies
Question 14. Default Time Of Log Shopping ?
Answer :
15 minutes
Question 15. Full Form Of Tuf?
Answer :
Transaction Undo file
Oracle Real Application Clusters Interview Questions
Question 16. List Of Tables Used In Log Shipping?
Answer :
Primary server Tables:
Log_shipping_primary_databases, Log_shipping_monitor_primary, log_shipping_monitor_error_detail, log_shipping_monitor_alert
Secondary server Tables:
Log_shipping_secondary_databases, Log_shipping_monitor_secondary, Log_shipping_monitor_error_detail, Log_shipping_monitor_alert, Log_shipping_monitor_history_detail, Log_shipping_secondary
Question 17. Backup Can Be Compressed In Log Shipping?
Answer :
Yes, SQL server 2008 onwards
Database Replication Interview Questions
Question 18. How To Troubleshoot Log Shipping Issues?
Answer :
Check errors log for issue
Check backup, copy, and repair task records.
Check Log shipping fashionable document
IDMS (Integrated Database Management System) Interview Questions