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: How to create a failover cluster

    1.In the Failover Cluster Manager snap-in, confirm that Failover Cluster Manager is selected and then, under Management , click Create a Cluster . 2.Follow the instructions in the wizard to specify: The servers to include in the cluster. The name of the cluster. Any IP address information...
  • Blog Post: Query SQL Server backup history and restore history records

    1.使用以下TSQL語法查詢備份檔紀錄 SELECT bs.backup_set_id, bs.database_name, bs.backup_start_date, bs.backup_finish_date, CAST(CAST(bs.backup_size/1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS [Size], CAST(DATEDIFF(second, bs.backup_start_date, bs.backup_finish_date) AS VARCHAR(4)) + ' ' + 'Seconds' [TimeTaken...
  • Blog Post: Setting Up SQL Server 2008 R2 Database Mirroring in a Workgroup

    1.Verify SQL Server service account and configure SQL Server Login for Database Mirroring (1)SQL Server service account Principal Server SQL Server service account is local account name "SQLServer" Mirroring Server SQL Server service account is local account name "SQLService" (2)create...
  • Blog Post: Service Accounts and Database Mirroring

    Service Accounts (Configure Database Mirroring Security Wizard) http://msdn.microsoft.com/en-us/library/ms189434.aspx When using Windows Authentication, if the server instances use different accounts, specify the service accounts for SQL Server . These service accounts must all be domain accounts...
  • Blog Post: Setting Up SQL Server 2008 R2 Database Mirroring with Certificate step by step in a Workgroup

    Setting Up SQL Server 2008 R2 Database Mirroring with Certificate step by step in a Workgroup LAB VM Principal Server: SQL2008R2M1 Mirroring Server: SQL2008R2M2 Witness Server: SQL2008R2M3 [Step by Step] 1.Create Database Master key, certificate and endpoint on Principal Instance...
  • Blog Post: Setting Up SQL Server 2008 R2 Log Shipping step by step

    Setting Up SQL Server 2008 R2 Log Shipping step by step 1.Prerequisites (1)確認資料庫復原模式recovery model為[完整](Full)或[大量記錄](bulk-logged) (2)建立一個交易紀錄備份用目錄並設定分享,如果只有兩台SQL Server通常建立在主要伺服器Primary Server上,此目錄也可以建立在第三台主機上。 此範例的目錄建立在主要伺服器上,C:\LogShip 並給予主要伺服器Primary Server的SQL Agent啟動帳戶SQLservice有寫入與讀取權限...
  • Blog Post: Setting Up SQL Server 2008 R2 Database Mirroring step by step

    Setting Up SQL Server 2008 R2 Database Mirroring step by step 1.Prepare a Mirror Database for Mirroring (1)在主體伺服器,對要設定鏡像的資料庫執行完整備份。(Create either a full database backup or a differential database backup of the principal database.) (2)執行交易紀錄檔備份(Take a log backup) Typically, you need...
  • Blog Post: Recovering a SQL Server cluster group and resources

    如何將誤刪的SQL Server Cluster Group加回 1.Create a new SQL Server resource group in Failover Cluster Manager. (1)Click [Services and Applications] and then, under Actions (on the right), click [Configure a Service or Application]。 (2)Select [Other Server]。 (3)Set SQL Server Cluster Virtual Name(SQL...
  • Blog Post: Quick to build a testing web site to access SQL Server

    Classic ASP How to access SQL Server in Active Server Pages http://support.microsoft.com/kb/169377/en-us ASP.NET 1.1 逐步解說:在 Web Form 網頁中顯示資料 Visual Studio .NET 2003 http://msdn.microsoft.com/zh-tw/library/cc438239(v=vs.71).aspx Walkthrough: Basic Data Access in Web Pages Visual Studio 2005 http...
  • Blog Post: Remove a crash SQL Cluster Node and add new SQL Cluster Node back to exist SQL Cluster

    如何移除一個硬體損毀的節點,並且重新加入原來的叢集 To recover from a failover cluster hardware failure 1.After Node 1 fails, the SQL Server failover cluster fails over to Node 2. 當節點1發生問題時,SQL Server會failover到節點2 2.Evict Node 1 from Microsoft Cluster Service (MSCS). To evict a node from MSCS, from Node 2, open Cluster...
  • 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...
  • Blog Post: AD account permission required for SQL Server failover Cluster Installation

    如果沒有Domain管理員的權限要安裝SQL Server Cluster需要在Active Directory額外設定一些電腦帳戶與權限,當參考以下這篇MSDN文件時常常會被一些名詞混淆。 Failover Cluster Step-by-Step Guide: Configuring Accounts in Active Directory http://technet.microsoft.com/en-us/library/cc731002(WS.10).aspx 文章裡面的cluster name account就是CNO也就是cluster computer account也就是一個在AD上的一個電腦帳戶...
  • Blog Post: Build a two-node SQL Server 2008 R2 Cluster with iSCSI

    Build a two-node SQL Server 2008 R2 Cluster with iSCSI Lab VMs: 1.iSCSITarget (Windows Storage Server 2008 R2 SP1) (DC and iSCSI Target Server) 2.SQL1 (SQL Server 2008 R2 on Windows 2008 R2 SP1) 3.SQL2 (SQL Server 2008 R2 on Windows 2008 R2 SP1) [Action Plan] 1.on SQL1 and SQL2 configure...
  • Blog Post: Add a node to an existing two-node SQL Server 2008 R2 Cluster

    Add a node to an existing two-node SQL Server 2008 R2 Cluster 如何新增一個節點到已經存在的SQL Server 2008 R2 Cluster Lab VMs: 1.DC (Windows 2003) 2.iSCSITarget (Windows Storage Server 2008 R2 SP1) 3.SQL1 (SQL Server 2008 R2 on Windows 2008 R2 SP1, existing SQL Cluster Node1) 4.SQL2 (SQL Server 2008 R2 on Windows...
Page 1 of 1 (15 items)