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: 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: Apply snapshot from Alternate folder to improve performance when initialize a Subscription in Transactional Replication

    Apply snapshot from Alternate folder to improve performance when initialize a Subscription in Transactional Replication 訂閱的初始化有兩個過程: 1.產生snapshot file,這個是snapshot agent所負責的工作。 Type of Replication Common Snapshot Files Snapshot Replication or Transactional...
  • 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...
  • Blog Post: How to Rename SQL Server Cluster Virtual Server Name(Network name)

    How to Rename SQL Server Cluster Virtual Server Name(Network name) Rename a SQL Server Failover Cluster Instance http://msdn.microsoft.com/en-us/library/ms178083.aspx The name of the virtual server is always the same as the name of the SQL Network Name (the SQL Virtual Server Network Name)....
  • Blog Post: 不允許儲存變更saving changes is not permitted

    不允許儲存變更saving changes is not permitted SQL Server 2008啟動SSMS,開始試試IntelliSence,Import,Export等基本功能,建了一個Table想要再Modify修改Table的Column欄位定義,出現錯誤 "不允許儲存變更saving changes is not permitted" 解法如下: 請開啟 SQL Server Management Studio (SSMS) 在 [ 工具 ] 功能表中上, 按一下 [ 選項 ] 在 [ 選項] 視窗,巡覽窗格中, 按一下 設計工具...
  • Blog Post: 使用一句SQL INSERT多筆Record(multiple values)

    使用一句SQL INSERT多筆Record(multiple values) 此功能在MySQL在3.22.5之後就有的功能, SQL Server在這個SQL Server 2008版本才加入此功能 -- 切換測試資料庫 USE MyDB GO -- 建一個測試資料表 CREATE TABLE [mytable] ( myid nvarchar(10) ,givenName nvarchar(50) ,email nvarchar(50) ); GO -- 一次Insert 多筆資料 INSERT INTO [mytable] VALUES ('01','Brad','brad@test...
  • Blog Post: SQL Server 2008 Installation on Vista Business Edition(在Vista安裝SQL Server 2008)

    SQL Server 2008 Installation on Vista Business Edition(在Vista安裝SQL Server 2008) SQL Server 2008安裝 執行SQL Server 2008光碟內的setup.exe會自動偵測並安裝以下兩個必要元件 1.Microsoft .Net Framework 3.5 SP1 2.Microsoft Installer(MSI) 4.5 再次執行setup.exe則會啟動SQL Server 2008安裝中心 在左邊選擇Installation 在右邊選擇第一個New SQL Server...
  • Blog Post: SQL Server 2008 與SQL Server 2005 Sample Databases範例資料庫下載與安裝

    SQL Server 2008 與SQL Server 2005 Sample Databases範例資料庫下載與安裝 SQL Server 2008安裝光碟已不再含有範例資料庫Sample Database,需自行到CodePlex網站的SQL Server Database Product Samples網頁下載 http://msftdbprodsamples.codeplex.com/ [SQL Server 2008] [SQL Server 2005] SQL Server 2008 Sample Database...
Page 1 of 1 (14 items)