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

High Availability (SSQA.net)

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

September 2007 - Posts

Can we do logshipping from sql 2005 to 2000? How it is different between 2 SQL versions?
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...
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...
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...
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...
Disaster Recovery - planning FAQ
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...