Brad Chen's SQL Server Blog

MS, SQL Server Support, Guidelines, Tips, Troubleshooting

Browse by Tags

Tagged Content List
  • Blog Post: SQL Server and SQL Server Agent Service Account(Startup Account) and Permissions

    SQL Server and SQL Server Agent service account(Startup Account) and Permissions 1.Does service account need sysadmin role? [SQL Server(Database Engine)] 沒有文件說明一定需要sysadmin role no document found saying No or Yes explicitly about if sql service account need to be a member of sysdamin role (1)SQL...
  • Blog Post: 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...
  • Blog Post: Manage a SQL Server failover cluster from command line or powershell

    1.顯示目前的網域裡的所有Cluster c:\Winodws\system32> cluster /list PS C:\Users\Administrator.domain> Get-Cluster 2.顯示目前的cluster的所有節點狀態 c:\Winodws\system32> cluster node PS C:\Users\Administrator.domain> Get-ClusterNode 3.顯示Quorum狀態 c:\Winodws\system32> cluster...
Page 1 of 1 (3 items)