Which table can you use to achieve the objective?

You are a database administrator for Verigon Corporation.
The company stores all its product-related data in a SQL Server 2008 database named Product that resides on the Sqlserver1 server.
You have configured asecondary database named Product_sec for the Product database to provide high availability for the database.
You must determine the log shipping specific configuration details of the Product database on the Sqlserver1 server.
Which table can you use to achieve the objective?

You are a database administrator for Verigon Corporation.
The company stores all its product-related data in a SQL Server 2008 database named Product that resides on the Sqlserver1 server.
You have configured asecondary database named Product_sec for the Product database to provide high availability for the database.
You must determine the log shipping specific configuration details of the Product database on the Sqlserver1 server.
Which table can you use to achieve the objective?

A.
log_shipping_primary_databases

B.
log_shipping_primary_secondaries

C.
log_shipping_monitor_primary

D.
log_shipping_monitor_history_detail

Explanation:

The log_shipping_primary_databases table is used to determine the log shipping specific configuration detailsof the Product database. The log_shipping_primary_databases
table contains configuration information aboutthe entire primary database on the server. In this scenario, the Product database is the primary database,therefore, you should refer to the log_shipping_primary_databases table to determine the configuration detailsof the database. This table contains one row for every primary database on the server and contains informationsuch as the backup directory, the backup retention time, and details of the most recent transaction log backup. The log_shipping_primary_secondaries
table cannot be used to determine the configuration details of the Product database. The log_shipping_primary_secondaries table displays a mapping of the primary databasesto the secondary databases.
The log_shipping_monitor_primary table cannot be used to determine the configuration details of the Product database. The log_shipping_monitor_primary table is used to monitor transaction log specific activities on theprimary database. The log_shipping_monitor_history_detail table cannot be used to determine the configuration details of the
Product database. The log_shipping_monitor_history_detail table stores history information for the logshipping jobs related to the primary database.

Objective:
Implementing High Availability

Sub-Objective:
Implement log shipping.

References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > Transact-SQLReference > System Tables (Transact-SQL) > Log Shipping Tables (Transact-SQL) >log_shipping_primary_databases (Transact-SQL)



Leave a Reply 0

Your email address will not be published. Required fields are marked *