MS SQL 2005 2008 2012 Mirroring

How to mirror MSSQL Database

=== PRINCIPAL ===
USE MASTER
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Password'
GO


---
USE MASTER
GO
CREATE CERTIFICATE Principal_Cert
WITH SUBJECT = 'Principal Certificate';
GO
---

CREATE ENDPOINT End_Mirroring
STATE = STARTED
AS TCP (LISTENER_PORT = 5022, LISTENER_IP = ALL)
FOR DATABASE_MIRRORING
(
AUTHENTICATION = CERTIFICATE Principal_Cert,
ENCRYPTION = REQUIRED ALGORITHM RC4,
ROLE = ALL
)
GO
---


USE MASTER
GO
BACKUP CERTIFICATE Principal_Cert
TO FILE = 'C:\Cert\Principal_Cert.cer'
GO

Lampu Alarm Avanza menyala terus

Jika anda iseng memijit-mijit tombol remote tipe ML-01102006 untuk membuka dan mengunci pintu pada remote control Avanza. Dan hasilnya adalah

1. Lampu merah di dashboard belakang stir jadi menyala terus (normalnya kedap kedip)

2. Ketika mengunci pintu tak keluar suara (normalnya keluar suara)

3. Ketika membuka pintu tak keluar suara (normalnya keluar suara)

Jika hal tersebut terjadi maka dicurigai alarm anda memasuki VALET MODE

Refresh DNS Cache Faster

For those manually configure the authoritative nameserver for a domain zone using BIND, modification has to be done in the zone file. For example, so domain zone example.com, you will see the following resource records in the zone file:

My Cell-Phone from Past to Present

My Cellular Phones from time to time... edit lagi ah.. last update 2009, now 2016.



NOKIA 3110 (1998)