Brad Chen's SQL Server Blog

MS, SQL Server Support, Guidelines, Tips, Troubleshooting

Browse by Tags

Tagged Content List
  • 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 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...
Page 1 of 1 (4 items)