Note: This question is a part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are designing a new high availability (HA) solution for a set of application databases. The solution will be contained within a single datacenter and provided instance-level HA protection.
You need to deploy a solution that allows for minimal downtime if the production server goes offline.
Which should you implement?
Note: This question is a part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You are designing a new disaster recovery (DR) solution for a heavily-utilized application database. The DR site is in a remote datacenter. You should minimize network traffic to the DR site during business hours.
You need to deploy a solution that allows near-real time queries to be run on the secondary instance and
minimizes the effect on performance for the main production database.
Which should you implement?
Which task should you perform before you can create a utility control point by using the service account option?
You run the sp_who system stored procedure. A process is blocked by a long-running operation.
You need to identify details of the processes involved in the deadlock including the resources that are being accessed. You must able to view the deadlock chain.
What should you use?
You maintain two Microsoft SQL Server instances that are hosted on two servers named SVR1 and SVR2.
You configure log shipping using the following information:
DB1 on SVR1 is configured as the primary database
Logs are backed up to a shared folder on SVR1
DB2 on SVR2 is configured as the secondary database
The service accounts for SQL Server Agent are set up using different domain accounts.
After changes are made to SVR1, log shipping is failing with the following error message:
You need to resolve the issue.
What should you do?