Category Archives: SQL Server

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 →

Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager. Steps I perform to resolve the issue, Seems to be a WMI error :- 1) If using Window Server 2008 & above, Run command from command prompt to verify WMI repository : … Continue reading →