Can mirroring be implemented using SMO.

I wanted know that is it possible to implement mirroring in C#.NET framework using SMO (I need specifically a web applicaton). which willl provide a naive user the facilities integrated in SSMS. I am using VS.NET 2005 and SQL Server 2005 SP1.
Thanks and Regards,
Adii

Can you please clarify your question.

Database mirroring is a feature provided in "SQL Server 2005 SP1". Can you please elaborate what you mean by "implementing" it?

|||Thanks Sanjay,
I wanted to know that are there any classes or APIs provided, so that I can programmatically achieve mirroring in my application. Does SMO namespace can provide any assistance in this? Please do let me know if you know or find some solution for the same. I have SQL Server 2005 SP1 installed, but I don't want to use SSMS for doing mirroring. I want to provide this facility in my application to the user programmatically.|||I too am very interested in this answer. We are looking to automate some of the setup and configuration and it would be nice to be able to use SMO or some other exposed APIs to do it with.

Can mirroring be implemented using SMO.

I wanted know that is it possible to implement mirroring in C#.NET framework using SMO (I need specifically a web applicaton). which willl provide a naive user the facilities integrated in SSMS. I am using VS.NET 2005 and SQL Server 2005 SP1.
Thanks and Regards,
Adii

Can you please clarify your question.

Database mirroring is a feature provided in "SQL Server 2005 SP1". Can you please elaborate what you mean by "implementing" it?

|||Thanks Sanjay,
I wanted to know that are there any classes or APIs provided, so that I can programmatically achieve mirroring in my application. Does SMO namespace can provide any assistance in this? Please do let me know if you know or find some solution for the same. I have SQL Server 2005 SP1 installed, but I don't want to use SSMS for doing mirroring. I want to provide this facility in my application to the user programmatically.|||I too am very interested in this answer. We are looking to automate some of the setup and configuration and it would be nice to be able to use SMO or some other exposed APIs to do it with.

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