Can I mirror a sql server 2000 DB in Sql Server 2005?

Can I use Databse Mirroring to mirror a DB from 2000 in to Sql server 2005?

No. To generate the process of setting mirroring you have to open Management Studio and select a 2005 database.

I should build a Integration Services package to copy data/objects from 2000 to 2005 periodically.

|||

Database Mirroring is a feature available only in sql 2005 .........you cannot use mirroring from sql 2000 to sql 2005......if you wish to move the dbs from sql 2k to sql 2k5 you can take backup in sql 2k of all your dbs and restore it in sql 2k5......or else you can also detach the dbs in sql 2k and attach it in sql 2k5.......refer the links for mirroring

http://sql-articles.com/articles/dbmrr.htmmoreover the dbs involved in mirroring shud have only full recovery model.b4 you configure mirroring refer these prerequisites,

http://sql-articles.com/articles/intdbmrr.htm

|||

I think restoring can be made after you are sure about upgrading db in good conditions, see|||

once you upgrade your box to sql 2005 as mentioned above you can configure mirroring.......inaddition to what i said earlier you need to have SQL 2005 SP1 or later in both partners as well as in witness

|||

Hi Deepak,

Thanks a lot for you reply. Your article helped me.

|||Also if you are looking for a DR or Reporting solution from SQL 2000 to SQL 2005 you could consider Replication.

HTH
Vishal