Configure SQL Server Database Mirroring

1) Take Full backup of database at Principle Server BACKUP DATABASE USERDB1 TO DISK = ‘H:USERDB1.BAK’ 2) Take Log Backup at Principle Server BACKUP LOG USERDB1 TO DISK = ‘H:USERDB1_LOG.TRN’ 3) Copy both backup files to Mirror server 4) Restore Full backup with No Recovery at Mirror Server USE [master] RESTORE DATABASE [USERDB1] FROM DISK … Continue reading ?