InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
How To Troubleshoot Log Shipping Issues? |
| Answer» | |
| 2. |
Backup Can Be Compressed In Log Shipping? |
|
Answer» Yes, SQL server 2008 onwards |
|
| 3. |
List Of Tables Used In Log Shipping? |
|
Answer»
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 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 |
|
| 4. |
Full Form Of Tuf? |
|
Answer» Transaction Undo file |
|
| 6. |
How To Monitor Log Shipping? |
| Answer» | |
| 7. |
What Is The Difference Between Log Shipping 2000 And 2005? |
|
Answer» Log SHIPPING 2005 uses link Server to communicate between PRIMARY, Monitor, and Secondary Servers. For 2000, Check connectivity of Primary, Monitor, and Secondary Servers. PLEASE note, ALWAYS check remote CONNECTIONS are enabled on all servers. Log shipping 2005 uses link Server to communicate between Primary, Monitor, and Secondary Servers. For 2000, Check connectivity of Primary, Monitor, and Secondary Servers. Please note, always check remote connections are enabled on all servers. |
|
| 8. |
Which System Database Store Log Shipping Related Information? |
|
Answer» Msdb Msdb |
|
| 9. |
What Are The Drawbacks Of Log Shipping ? |
Answer»
|
|
| 10. |
What Are The Benefits Of Log Shipping? |
| Answer» | |
| 11. |
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 mode – Database is in read-only node. You can select the data from the database. This database can be used for REPORTING PURPOSE. Restoring mode – Database is in restoring mode. You can not access the database. Stand by mode – Database is in read-only node. You can select the data from the database. This database can be used for reporting purpose. |
|
| 12. |
Types Of Secondary Server? |
|
Answer» RESTORING MODE and STAND by mode Restoring Mode and Stand by mode |
|
| 13. |
Login Can Be Transferred Through Manual Failover? |
|
Answer» No, you have to CREATE LOGINS and USERS on SECONDARY SERVER. No, you have to create logins and users on secondary server. |
|
| 14. |
Whether Log Shipping Supports Automatic Failover? |
|
Answer» No, it SUPPORT only MANUAL FAILOVER. No, it support only manual failover. |
|
| 15. |
Which Jobs Are Created In Log Shipping? |
|
Answer» On Primary server – Backup JOB On SECONDARY Sever – Copy, Restore and ALERT JOBS On Primary server – Backup job On Secondary Sever – Copy, Restore and Alert Jobs |
|
| 16. |
Required Recovery Models In Log Shopping? |
|
Answer» FULL or BULK LOGGED RECOVERY MODEL Full or Bulk logged Recovery Model |
|
| 17. |
Who Can Setup Log Shipping? |
|
Answer» MEMBERS of SYSADMIN FIXED SERVER ROLE Members of Sysadmin fixed server role |
|
| 18. |
Which Edition Support Log Shipping? |
Answer»
|
|