SQL Server Database Mirroring has 5 different states. According to BOL (http://technet.microsoft.com/en-us/library/ms189284.aspx) :- Mirroring state Description SYNCHRONIZING The contents of the mirror database are lagging behind the contents of the principal database. The principal server is sending log records to the mirror server, which is applying the changes to the mirror database to roll it … Continue reading →

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 →

Question : When you take full backup, do it capture data till the time backup start time or till the time backup end. Answer : Full backup capture database till the backup completion time. Let check it :- 1) I have initiated the TEST database backup with buffercount =1 so that backup took some time … Continue reading →

Finally after a long waiting period, Microsoft release SQL Server 2008 Service Pack 4, Same is now available for download at the Microsoft Support site. SQL Server 2008 Service Pack 4 contains all the hotfixes released since the initial release of SQL Server 2008 RTM. I suggest to test SQL Server 2008 Service Pack 4 … Continue reading →

Finally after a long waiting period, Microsoft release SQL Server 2008 R2 Service Pack 3, Same is now available for download at the Microsoft Support site. SQL Server 2008 R2 Service Pack 3 contains all the hotfixes released since the initial release of SQL Server 2008 R2 RTM. I suggest to test SQL Server 2008 … Continue reading →