problem in creation database mirroring

Hi everyone,
Can anyone tell me how I can create a mirror database?
please give me the information step by step.
Thanks,
Nassa
Nassa,
there is a Technet webcast on Mirroring:
http://whitepapers.techrepublic.com.com/thankyou.aspx?&docid=157789&view=157789&load=1
Apart from that, I'd use BOL as the main source of info. If possible, you
might want to get yourself on the 3-day Microsoft Course 2788:
http://www.microsoft.com/learning/syllabi/en-us/2788afinal.mspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||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@.gmail.com> wrote in message
news:1168853360.943120.231280@.38g2000cwa.googlegro ups.com...
> Hi everyone,
> Can anyone tell me how I can create a mirror database?
> please give me the information step by step.
> Thanks,
> Nassa
>
|||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:[vbcol=seagreen]
> 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@.gmail.com> wrote in message
> news:1168853360.943120.231280@.38g2000cwa.googlegro ups.com...
|||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@.gmail.com> wrote in message
news:1168934654.927792.65420@.11g2000cwr.googlegrou ps.com...
> 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:
>
|||Hilary Cotter,
yes it is SQL 2005 server and I use SQL server management studio
express.
What should I do?Which SQL should I use?
Thanks,
Nassa
Hilary Cotter wrote:[vbcol=seagreen]
> 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@.gmail.com> wrote in message
> news:1168934654.927792.65420@.11g2000cwr.googlegrou ps.com...
sql