Browse by Tags
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...
In continuation to Tech-ed North America - what I'm doing there? & Say goodbye to Tech-ed 2008 Developers and say hello to IT-PRO! posts here and to wrap up the earlier posts about Tech-ed Online Panel: Leveraging SQL Server Technologies to Build
Read More...
Are you visiting Tech-ed, North America? Tech·Ed offers the premier technical education conference just for IT professionals. Microsoft and industry experts will share their expertise about how to architect, deploy, manage, and help secure a connected
Read More...
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...
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...
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...
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...
* SQLAgent service should run under same domain account, which has local admin privilege and “Log in as a service” permission. This requires on both the server. In case, if SQL Server is not part of any Domain. We can use the user account which has identical
Read More...
When configuring log shipping on a highly transactional environment (with SQL Clustering setup), we were hit by above error. All the Logins and their privileges are intact within the primary and standby servers along with Local server policies & group
Read More...
This was the question asked by one of the user in the forums. Precisely the answer is no, as you cannot restore a log or database from SQL 2005 to 2000 version due to the differences in the design. Moreover for the sake of high availability the method
Read More...
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...
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...
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...
Whether you're still in the planning stages, or you're trying to refine your organization's disaster recovery processes, this recently updated FAQ guide has information that can help. DR-Q&A
Read More...
How to protect and secure data in the event of a disaster? It's not possible to anticipate every possible disaster your organization may encounter, but you don't have to. Discover a wealth of information about how to protect and secure your data in the
Read More...