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: 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: Windows 2012 Failover Cluster Management Console Error "A weak Event was created and it lives on the wrong object"

    最近因為客戶的需求在Windows Server 2012上安裝一組SQL Server 2012 Failover Cluster,遇到以下問題,以下是解決方法: [Symptoms] When you opened Failover-Manager and clicked on Roles or Nodes you get the following error. A weak Event was created and it lives on the wrong object, there is a very high Chance this will fail, please...
  • Blog Post: Install SQL Server 2012 Failover Cluster with Command Line and Configuration File

    Install SQL Server 2012 Failover Cluster with Command Line and Configuration File 1.安裝設定好Windows 2008 R2 Failover Cluster。 可參考這一篇的前半部 Build a two-node SQL Server 2008 R2 Cluster with iSCSI 2.安裝SQL Server Failover Cluster之前,必須在兩個節點先安裝.Net Framework 3.5.1。 可以透過Server Manager或PowerShell的方式來安裝...
  • Blog Post: Install SQL Server 2012 with command line

    Install SQL Server 2012 with command line 1.安裝SQL Server之前,必須先安裝.Net Framework 3.5.1。 可以透過Server Manager或PowerShell的方式來安裝。 (1)使用Server Manager安裝。 (2)使用PowerShell安裝。 A.以系統管理員身分啟動PowerShell命令提示字元。 B.輸入以下命令。 Import-Module ServerManager Add-WindowsFeature NET-Framework-Core...
  • Blog Post: Setup SQL Server 2012 AlwaysOn Availability Groups using Certificate

    Setup SQL 2012 AlwaysOn Availability Groups using Certificate 1.如果SQL Server的啟動帳戶使用本機帳戶或虛擬帳戶Virtual Account(本機受管理的服務帳戶Managed Local Accounts),若要在這種環境下設定AlwaysOn,則必須使用憑證Certificate來設定。 安裝SQL Server 2012時SQL Server服務的預設啟動帳戶就是Virtual Account,也就是NT Service\MSSQLSERVER 以下範例:2個Instance都是使用NT Service...
  • Blog Post: Setup SQL Server 2012 AlwaysOn Availability Groups using Join Only

    Setup SQL 2012 AlwaysOn Availability Groups using Join Only 1.事先將主要Instance上的MyDB資料庫做備份(a Full Backup and a Log Backup)並指定NO RECOVERY 還原到第二個Instance。 -- 第1個也就是主要的Instance SQL2012A1 BACKUP DATABASE [MyDB] TO DISK = N'C:\Temp\MyDB.bak' GO BACKUP LOG [MyDB] TO DISK = N'C:\Temp\MyDB.trn' GO ...
  • Blog Post: Setup SQL Server 2012 AlwaysOn Availability Groups using Skip initial data synchronization

    Setup SQL 2012 AlwaysOn Availability Groups using Skip initial data synchronization 1.在選取初始資料同步處理時,選擇[略過初始資料同步處理](Skip initial data synchronization) 2.驗證時會略過很多項目 3.完成時也會略過很多項目 4.此時AG新增成功,因為第二的Instance還沒有MyDB資料庫存在,所以在第二個Instance的可用性資料庫會出現驚嘆號 5.啟動[顯示儀表板],第二個Instance的MyDB會出現驚嘆號...
  • Blog Post: Quick Setup a SQL Server 2012 AlwaysOn Availability Groups

    Quick Setup a SQL 2012 AlwaysOn Availability Groups 以下範例所有Instance的SQL Server啟動帳戶都同一個網域帳戶(domain user account),如果您的SQL啟動帳戶是本機帳戶或虛擬帳戶Virtual Account(本機受管理的服務帳戶Managed Local Accounts),請參考這篇 Setup SQL Server 2012 AlwaysOn Availability Groups using Certificate 使用憑證來設定AlwaysOn AD Domain User Account...
  • Blog Post: SQL Server 2012 certifications

    Microsoft SQL Server certifications http://www.microsoft.com/learning/en/us/sql-certification.aspx MCSA->MCSE->MCSM Microsoft Certified Solutions Associate (MCSA) SQL Server 2012 MCSA (required exam: 461 + 462 + 463) 70-461 (Training 10774) Querying Microsoft SQL Server 2012 70-462 (Training...
  • Blog Post: SQL Server 2012 Installing on Windows Server 2012, Error while enabling Windows feature : NetFx3, Error Code : –2146498298

    1.安裝過程發生Error while enabling Windows Feature NetFx3, Error Code : –2146498298 的警告。 Error while enabling Windows feature : NetFx3, Error Code : –2146498298 , Please try enabling Windows Feature : NetFx3 from Windows management tools and then run setup again. 2.解決方法是在安裝SQL Server...
  • Blog Post: SQL Server 2012 Installation fail "Managed SQL Server Installer has stopped working"

    SQL Server 2012 Installation fail "Managed SQL Server Installer has stopped working" 在Windows 8上安裝了SQL Server 2012 Developer Edition RTM出現一個錯誤"Managed SQL Server Installer has stopped working",搜尋網路上的資源都指向是.net framework的問題,試了很多方法,最後的解決方法是將Windows 8 內建的.Net Framework 3.5與4.5所有子功能都一併安裝起來才解決的。 我的狀況如下...
Page 1 of 1 (13 items)