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 » 2005 » sql server   (RSS)
Tech-ed Online Panel: Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy
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...
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...
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...
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...
Is it possible to run SQL Server 2000 and 2005 version on same cluster?
Yes. This is supported as SQL Server 2005 and 2000 can be installed side by side on a cluster successfully. With regard to achieve this there should be more care on choosing the shared- disks & IP addresses with sensible resourced hardware. 1. Separate Read More...