Set up 2 Windows 2016 Servers and install Microsoft SQL 2014 oneach VM. Create a new instance and name is as per our namingconvention. (should already have this in existingdeployment) Create a SQL Administrator account (in ActiveDirectory) called SQLAdmin and grant theaccount Local Administrator privileges on both SQL Servers. Also,give this account SysAdmin Role permissions in each SQL instanceand set the Services (SQL Server, and SQL AGENT) to log on as thisaccount.
Restore the SQLDatabase AdventureWorks2012 (fullbackup) located at one of the following locations:
From the assignment folder (adventureworks bak file ineconestoga)
Set up SQL Mirroring from one SQL Server to another (usingSQL Server Management Studio is preferred over T-SQL for ease ofuse but not required).
After this has been successfully completed, please provide thefollowing information in a single PDFdocument for manager purposes:
Document Deliverables 80%
Manager Presentation
You will record a video presentation of a working SQL Mirrorfrom your SQL Server. You must cover the followingareas:
You can leverage the following link when setting up SQLMirroring:
https://docs.microsoft.com/en-us/sql/da ... sql-server
CONFIGURE A WITNESS SERVER (USE YOUR EXISTING DOMAINCONTROLLER) FOR AUTOMATIC FAILOVER
In order to get any bonus marks thefollowing must be met:
Set up 2 Windows 2016 Servers and install Microsoft SQL 2014 on each VM. Create a new instance and name is as per our na
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am