Oracle Client for SQL Server

Oracle Client for SQL Server Oracle Client Support Windows version Document / Download Oracle 12c for Microsoft Windows x64 (64-Bit) •Windows Server 2008 x64 and Windows Server 2008 R2 x64 – Standard, Enterprise, Datacenter, Web, and Foundation editions. •Windows 7 x64 – Professional, Enterprise, and Ultimate editions •Windows 8 x64 and Windows 8.1 x64 -…

0

SQL Server and SQL Server Agent Service Account(Startup Account) and Permissions

SQL Server and SQL Server Agent service account(Startup Account) and Permissions SQL Server與SQL Server Agent 服務帳戶(啟動帳戶)與權限 可設定的種類 1.Domain User Account (使用一個網域使用者帳戶) 2.Local User Account (使用一個本機使用者帳戶) 3.Local Service Account (NT AUTHORITY\LOCAL SERVICE) 本機服務帳戶 4.Network Service Account (NT AUTHORITY\NETWORK SERVICE) 本機網路帳戶 5.Local System Account (NT AUTHORITY\SYSTEM) 本機系統帳戶 6.Virtual Accounts (start from Windows 7 and Windows Server 2008…

0

AlwaysOn Availability Groups learning resources

Overview of AlwaysOn Availability Groups (SQL Server) http://msdn.microsoft.com/en-us/library/ff877884.aspx Prerequisites, Restrictions, and Recommendations for AlwaysOn Availability Groups (SQL Server) http://msdn.microsoft.com/en-us/library/ff878487.aspx SQL AlwaysOn Team Blog http://blogs.msdn.com/b/sqlalwayson/ SQL Server Customer Advisory Team http://blogs.msdn.com/b/sqlcat/ MSDN Blogs  >  Brad Chen’s SQL Server Blog   >  All Tags  >  alwayson http://blogs.msdn.com/b/bradchen/archive/tags/alwayson/ AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution…

0

Manage a SQL Server failover cluster from command line or powershell

1.1 目前的Cluster Name c:\Windows\system32\cluster /prop PS C:\Users\Administrator.domain>Get-Cluster | fl * 1.2 顯示目前的網域裡的所有Cluster c:\Winodws\system32>cluster /list    PS C:\Users\Administrator.domain>Get-Cluster PS.Windows 2008 R2必須先Import failover cluster module PS C:\Windows\system32>Import-Module FailoverClusters   2.顯示目前的cluster的所有節點狀態 c:\Winodws\system32>cluster node   PS C:\Users\Administrator.domain>Get-ClusterNode 3.顯示Quorum狀態 c:\Winodws\system32>cluster /quorum PS C:\Users\Administrator.domain>Get-ClusterQuorum 4.顯示所有叢集群組 c:\Winodws\system32>cluster group   PS C:\Users\Administrator.domain>Get-ClusterGroup PS.可以查看目前Quorum在哪一個節點   顯示叢集群組(叢集應用程式)屬性 PS C:\Users\Administrator.domain>Get-ClusterGroup “叢集群組” | fl *    …

0