Recently got stuck with the stored procedure sys.sp_dbmmonitorupdate which is used to monitor the database mirroring session. As usual you could do using the GUI tool, but sometimes using TSQL methods is good enough to see what is happening on your system.
Read More...
The above error is quite common within the database mirroring setup, you could get to see. The intial workaround for this error will be to check whether any network issues are causing this error when the failover is intiated from a Primary server to the
Read More...
Mount Point is the new concept introduced in the Windows 2003 Server (R2) that works as a mounted drive is a volume or a drive that is mapped to a folder on a volume that uses the NTFS file system. Mounted drives function as any other volume or drive.
Read More...
Various options availability from the SQL Server using a Cluster and Standby server technologies, this whitepaper helps you to understand what best or solution can be applied to your business availability & continuity.
Read More...
Bob Beauchemin from SQL Skills released a white paper highlighting the operational and administrative tasks associated with SQL Server that help ensure a more secure SQL Server system. The whitepaper can be downloaded from here
Read More...