Does SQL Server 2000 Support High-Availability

Question

I have a SQL Server 2000 Standard Edition, will it support High-Availability?
And I want to move one of my server to 2014 server. Is SQL Server 2000 is compatible with 2014+ editions?

Also, I have SA for SQL VM. Azure has Hybrid benefit on Azure SQL VM. This Hybrid is beneficial for those VM which need DR. So, how can we setup HA in SQL Server Standard Edition by using the Azure Hybrid Benefit.

Answer 1

Hi @Sarvesh Pandey ,

As far as I know you cannot restore a SQL Server 2000 database to a SQL Server 2014 instance. You will need to restore either to SQL Server 2008 or 2008 R2 instance first, and then take a backup of that database which you can then restore to 2014.

There a lot of features from SQL Server 2000 that have been discontinued in SQL Server 2014. Check THIS list for the details about what features have been discontinued, and what to use as replacements.

SQL Server 2000 does support high availability, you'll find more information here:

Microsoft SQL Server 2000 High Availability Series
https://learn.microsoft.com/en-us/previous-versions//cc966499(v=technet.10)

Here are a few links that may help you in migrating your SQL Server 2000 databases to SQL Server 2014:

• SQL Select: Steps to Migrate from SQL Server 2000 to SQL Server 2014
• Migration of a large enterprise from SQL Server 2000 to 2014. Real life case.

----------

(If the reply was helpful please don't forget to upvote or accept as answer, thank you)

Best regards,
Leon