step by step mirroring sql server 2008 -with domain
TRANSCRIPT
Step by Step Database Mirroring
Langkah-langkah Mirroring Database di Workgroup Dengan DomainSQL Server 2008 Tanpa Server WitnessMengubah Service SQL Server dijalankan oleh user domainTambahkan Hostname di etc/hostsFull backup database PrincipalTransaction Log backup database PrincipalRestore Full backup di database MirrorRestore Transaction Log di database MirrorSetup MirroringStep Database MirroringMengubah Service SQL Server
Klik Kanan Properties pada Service SQL Isi dengan user domain Lakukan di kedua server (Principal & Mirror)Ubah untuk service:SQL ServerSQL Server AgentSQL Server BrowserMengubah Service SQL Server
Mengubah etc/hosts
Daftarkan IP dan Hostname Principal & Mirror di kedua serverMenggunakan Command T-SQL:BACKUP DATABASE TO DISK = /.bakMenggunakan SQL Server Management StudioFull Backup Database PrincipalMenggunakan Command T-SQL:BACKUP LOG TO DISK = /.trnMenggunakan SQL Server Management Studio
Transaction Log Backup Database PrincipalMenggunakan Command T-SQL:RESTORE DATABASE FROM DISK = N/.bak WITH FILE = 1, MOVE N TO N/.ldf NORECOVEY, NOUNLOAD, STATS = 10Menggunakan SQL Server Management Studio, dengan opsi NO RECOVERYRestore Full Backup di Database MirrorRestore Full Backup di Database Mirror
Klik Kanan di DatabaseRestore Full Backup di Database Mirror
Restore Full Backup di Database Mirror
Sesuaikan dengan folder database MirroringMenggunakan Command T-SQL:RESTORE LOG FROM DISK = N/.trn WITH FILE = 1, NORECOVEY, NOUNLOAD, STATS = 10Menggunakan SQL Server Management Studio, dengan opsi NO RECOVERYRestore Transaction Log di Database MirrorRestore Transaction Log di Database Mirror
Klik Kanan di DatabaseRestore Transaction Log di Database Mirror
Restore Transaction Log di Database Mirror
Dari CMDnetstat -aon | find ":Pastikan tidak adaPengecekan Port
Setup Mirroring
Klik Kanan di Database
Configure SecurityConfigure Security
Configure Security
Tidak menggunakan witness server
Configure SecurityPort yang digunakan
Configure SecurityPilih server mirroringConnect ke server mirroringConfigure Security
Configure SecurityDiisi dengan user domain, misalnya: sequis-jkt\sqlglassConfigure Security
Start/Pause/Remove MirroringStart Pause RemoveInformasi bahwa mirroring sudah berjalanSebelum failover database, sesuaikan link aplikasi ke database (jika diperlukan) FailoverFailover
Failover
FailoverWarning failoverFailover
USE MASTERGO
ALTER DATABASE SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
GO
Jika Principal Server DownTerima Kasih