Hi
Is it possible to use Database Mirroring when running a SQL Server 2005 database in compatibility mode 80 (SQL Server 2000)?
If upgrading to SQL Server 2005 we would have to run Principal, Mirror and Witness in mode 80 to support our Transact-SQL Queries. To upgrade our Queries would be equally (or more) costly then to buy new SAN hardware for a cluster in wich case we might well continue running our 2000 cluster. (Buying hardware is slightly more time efficent then rewriting some 1500 queries)
Please advise, thank you
Hi Pmela
The database mirroring will work for databases running in 2000 compatibility mode.
Jag
|||Thank you for your reply Jag!
I've already installed 2 instaces of the SQL Server 2005 180-Trial and tested this myself. It is working great 
No comments:
Post a Comment