Re: problem in creation database mirroring

Tech-Archive recommends: Fix windows errors by optimizing your registry

This is SQL 2005 right? You are running at the 90 compatibility level? And
it SQL 2005 Standard and above. Workgroup and Express do not support
database mirroring.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Nassa" <nassim.czdashti@xxxxxxxxx> wrote in message
news:1168934654.927792.65420@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hilary Cotter,

I try to do that before,but by right clicking on the database, and try
Task,then I dont have any menu like MIRRORING.
What should I do?

Thanks,
Nassa


Hilary Cotter wrote:
You need two SQL Servers - ideally 3. They can be on the same machine or
on
different machines.

In SQL Server Management Studio right click on your database and select
Tasks and Mirror, then select Security button. This will launch the
mirroring wizard. Click Next, click no for Witness (for now), click Next,
click Next at the Choose Servers to configure, accept the defaults for
the
principal server instance click Next, Accept the defaults for the mirror
server instance you will have to select your mirror server/instance here.
Click Next, for the Enter the Service accounts dialog click next, and
click
Finish.

This should get you operational.
--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Nassa" <nassim.czdashti@xxxxxxxxx> wrote in message
news:1168853360.943120.231280@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi everyone,

Can anyone tell me how I can create a mirror database?
please give me the information step by step.

Thanks,
Nassa




.

Quantcast