locked
Database Mirroring in comp. mode 80 RRS feed

  • Question

  • 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

     

     

    Tuesday, May 22, 2007 1:18 PM

Answers

  • Hi Pmela

     

    The database mirroring will work for databases running in 2000 compatibility mode.

     

    Jag

    Wednesday, May 23, 2007 5:28 PM

All replies

  • Hi Pmela

     

    The database mirroring will work for databases running in 2000 compatibility mode.

     

    Jag

    Wednesday, May 23, 2007 5:28 PM
  • 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 Smile 

    Friday, May 25, 2007 1:13 PM