顯示具有 Cluster 標籤的文章。 顯示所有文章
顯示具有 Cluster 標籤的文章。 顯示所有文章

2018年4月26日 星期四

SQL 2014 Server HA failover solution without shared storage installation process

1. Base OS
2. Check MBR disk type D: disk
3. Add .NET Framework 3.5 and Failover features
4. Install SQS 2014, SP2, Balance Data Distributor
5. Enable Cluster Service
6. Check SQL/Cluster service works
7. Enable Always-on and 
8. Create new sql listener by creat Availability Group wizard (Bad)
9. Import and configure replica DB
























No disk in it since we do not have SAN Share Storage












Final

2017年10月18日 星期三

Windows 2012 cluster validation wizard disk failed GPT disk


To change a GUID partition table disk into a master boot record disk using command line
Back up or move all volumes on the basic GUID partition table (GPT) disk you want to convert into a master boot record (MBR) disk.


  1. Open an elevated command prompt and type diskpart. If the disk does not contain any partitions or volumes, skip to step 6.
  2. At the DISKPART prompt (right-click Command Prompt, and then click Run as Administrator), type list disk. Make note of the disk number you want to delete.
  3. At the DISKPART prompt, type select disk <disknumber>.
  4. At the DISKPART prompt, type clean.






To change a GUID partition table disk into a master boot record disk using the Windows interface
  1. Back up or move all volumes on the basic GUID partition table (GPT) disk you want to convert into a master boot record (MBR) disk.
  2. If the disk contains any partitions or volumes, right-click any volumes on the disk and then click Delete Volume.
  3. Right-click the GPT disk that you want to change into an MBR disk, and then click Convert to MBR disk.

Docker Command

#1 pull images $docker pull chusiang/takaojs1607 #2 list images $docker images #3.1 run docker $docker run -it ### bash #3.2 run do...