Thanks Steve for your time !

regards

So, I am right if I say than the big question is :

Does SQL Server database mirroring protect the mirror database against physical corruptions that occur in the storage layer...

hi,

thanks for your answer.

Can I use a domain account for the mirroring purpose only and stay with SQL Server Service run with NT Service\mssqlserver ?

Which privilege do I need to...

Thanks for your answer.

bye !

Hi,

the objective is to have HA/disater/recovery scenario.

regards

C

Hi all,

Thanks for all your answer.

Very helpful !

regards

Cygne

The sql server version is 2008 sp2 (10.0.4000)

Great !

Thanks for your answer !

thanks for your script.

Hi,

do you have scripts examples of configure alerts in the SSMS ?

thanks !

hi,

my user1 exist only in the msdb database.

I tried but it not working:

use master

go

GRANT SELECT ON sys.database_mirroring TO user1;

go

Msg 15151, Level 16, State 1, Line 2

Cannot find the user 'user1',...

Okay, but if we do not use ADO or SNAC, can we change the ip address of the mirror wihtout confuse the database mirroring or should we instead change...

Thanks all for you answers.

Have a nice day!

But I still not understand why ?

In safety-mode, principal do not applied change on datafile until it's write in transaction log of the mirror.

So, if principal crashed, the transaction not...

Thanks for your answer.

It's clear now.

best regards