Welcome to SqlServer-QA.net Sign in | Join | Help

High Availability (SSQA.net)

Importance of Service Delivery within your environment, know more here.

Browse by Tags

All Tags » database mirror... » sql server   (RSS)
SQLPASS Summit 2008 - Effective Usage of Database Mirroring SQL 2005 & 2008
Its the last day of SQLPASS Summit 2008 and in few hours time I will be presenting my talk (first time in US SQLPASS) on " Effective Usage of SQL Server 2005 Database Mirroring, what's new in SQL 2008 " topic which is an enhanced version of what I have Read More...
Posted: Friday, November 21, 2008 10:40 AM by SQL Master | 2 Comments
Filed under: , , , , ,
SQL Server 2005 Database Mirroring choosing optimum value for auto-failover timeout?
Choosing a better plan to reduce outage to your database application is a beginner to provide High Availability to your application, irrespective to database or server. You may be aware that SQL Server 2005 version provides the database mirroring which Read More...
Posted: Monday, May 12, 2008 2:25 AM by SQL Master | 7 Comments
Filed under: , , , , , , , ,
SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?
When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By Read More...
Posted: Thursday, May 08, 2008 1:42 AM by SQL Master | 2 Comments
Filed under: , , , , , , , , , ,
Setting up Database Mirroring using Local Account
We had a need to setup Database Mirroring for a Disaster Recovery Project. We were at time running SQL 2005 Std SP1. i had to start the SQL Server Service with the startup parameter -T1400 to enable Mirroring. For DB Mirriring to work the SQL Server Service Read More...
Posted: Monday, March 10, 2008 7:43 AM by Akthar | 6 Comments
Filed under: , , , , ,
Database Mirroring sys.sp_dbmmonitorupdate stored procedure fails with error "Incorrect syntax near '-'"
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...
Posted: Monday, November 12, 2007 2:23 AM by SQL Master | 2 Comments
Filed under: , , , , , , , , ,
Database Mirroring: naming resolution issues during failover connectivity
Within a Database Mirroring session within an automatic failover situation it may fail with the error : "The server network address "%.*ls" can not be reached or does not exist. Check the network address name and reissue the command". If you suspect DNS Read More...
Posted: Monday, September 24, 2007 8:13 AM by SQL Master | 3 Comments
Filed under: , , , , , , , ,
SQL Server Database Mirroring error with TCP port numbers, firewall involvement
Lately we have been getting complaints that database mirroring setup on few of our client's site were failing with TCP related errors. For more information these sites are involved within the firewall setup and active directory too. Initial workaround Read More...
Posted: Thursday, September 13, 2007 8:35 AM by SQL Master | 1 Comments
Filed under: , , , , , , , , ,
Database Mirroring: Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
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...
Posted: Wednesday, September 12, 2007 7:56 AM by SQL Master | 1 Comments
Filed under: , , , , , ,