複寫疑難排解 Replication Troubleshooting

複寫疑難排解 Replication Troubleshooting   從TLog讀取 sp_replcounters (Transact-SQL) Returns replication statistics about latency, throughput, and transaction count for each published database. This stored procedure is executed at the Publisher on any database. sp_replcounters sp_repltrans (Transact-SQL) Returns a result set of all the transactions in the publication database transaction log that are marked for replication but have…

0

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

Manage a SQL Server failover cluster from command line or powershell 使用Command line或PowerShell管理SQL Server failover Cluster 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.顯示所有叢集群組…

0