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 a local account “SQLservice” on Principal Server create a login for local account “SQLservice” (3)create a…

2

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 (in the same or trusted domains). If all the server instances use the same domain account or use certificate-based authentication, leave the…

0

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(SQL2008R2M1) USE master GO SELECT * FROM sys.symmetric_keys GO CREATE MASTER KEY ENCRYPTION BY PASSWORD=’P@ssw0rd’;…

3

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有寫入與讀取權限   (3) 建立一個放置要還原的交易紀錄檔目錄並設定分享,此目錄建立在次要伺服器secondary Server主機上。 此範例的目錄建立在次要伺服器上,C:\LogShipRestore 並給予次要伺服器secondary Server的SQL Agent啟動帳戶SQLservice有寫入與讀取權限   2.Prepare a Secondary Database for Log Shipping (1)在主要伺服器上對要設定log shipping的資料庫執行完整備份。 (2)在執行一次交易紀錄檔備份。 (3)複製備份檔到次要伺服器。 (4)在次要伺服器,以WITH NORECOVERY參數還原完整備份與交易紀錄檔備份。 還原後資料庫狀態為(正在還原中)(Restoring)   3.開始設定Log Shipping (1)在主體伺服器設定主體資料庫屬性 (2)在選取頁面點選[交易紀錄傳送],右邊勾選[將此啟用為記錄傳送組態的主要資料庫] Under Select a page, click Transaction Log…

0

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 to take at least one log backup on the principal database. However, a log backup…

1

Burn an ISO image to physical DVD media with Windows 2008 R2 build-in tool "isoburn.exe"

  1.You must have the Desktop Experience pack installed    必須安裝桌面體驗 2.Windows Server 2008 R2 machines allow only the localsystem\administrator account permission to burn a CD/DVD on the local machine    必須使用預設的本機管理員帳戶localsystem/Administrator才能在本機燒錄光碟。 3.如果你的登入帳戶不是本機管理員帳戶localsystem/Administrator,則使用以下步驟:  (1)啟動命令提示字元,切換成localsystem/administrator身分再啟動一個命令提示字元。      C:\Users\CONTOSO.bradchen>runas /user:administrator cmd  (2)輸入本機管理員Administrator的密碼之後按確定,就會跳出新的命令提示字元。  (3)在新的命令提示字元輸入以下命令來燒錄。      C:\Windows\system32>isoburn /Q D: “C:\en_sql_server_2012_enterprise_edition_x86_x64_dvd_813294.iso”      PS.以上範例D:燒錄光碟機代號        [Reference] Windows Server 2008: How to…

0

Microsoft Office Access Performance Tuning Guide

1.依據KB209126的建議來最佳化查詢效能。Information about query performance in an Access databasehttp://support.microsoft.com/kb/209126 我們遇到一個案例,當Access使用[更新查詢](Update Query)更新大量的外部Oracle資料時,將[發生錯誤就失敗]設定為[是](change FailOnError to Yes on Query Properties),可以大幅改善執行效能。 2.當Access存取外部資料庫,例如SQL Server,如果可以就使用通過查詢(pass-through query),因為通過查詢可以直接將SQL語句傳送到SQL Server上執行,可以獲得最好的執行效能。How to create an SQL pass-through query in Accesshttp://support.microsoft.com/kb/303968 相同的案例,當Access需要更新大量的外部Oracle資料時,改用通過查詢(pass-through query),執行速度比[發生錯誤就失敗]設定為[是](change FailOnError to Yes on Query Properties)更快速。

0

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 Network Name) and SQL Server Virtual IP。 (4)Select your SQL Server Shared Disk。 (5)Select SQL…

0

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 Replication schema (.sch);  data (.bcp); constraints and indexes (.dri); constraints (.idx); triggers  (.trg):for updating Subscribers only; compressed snapshot files (.cab). Merge  Replication schema (.sch);  data (.bcp);…

0

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 Review and make changes on your code to prevent the…

0