I want to test break of mirror db when syncronization no longer possible

Hi

I am testing high performance mirror on my local PC

mirroring set on db Northwind between default and named instance

on default (principal) server have few jobs

1. insert into table A,run every 1 minute

2. backup log of Northwind ,run every 10 minute

3. stop named instance ,run every 15 minutes

4. start named instance ,run every 20 minutes

After each stop/ start mirrored db very quickly synchronized .

I want to test break of mirror db when synchronization no longer possible

any suggestions ?

We want to place 70 GB db in mirror 300 km away and I want test everything

All possible break scenario

I didn't understand your question completely "I want to test break of mirror db when synchronization no longer possible". However, the following document describes quite a few test scenarios for database mirroring, and may be helpful.

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

I want to test break of mirror db when syncronization no longer possible

Hi

I am testing high performance mirror on my local PC

mirroring set on db Northwind between default and named instance

on default (principal) server have few jobs

1. insert into table A,run every 1 minute

2. backup log of Northwind ,run every 10 minute

3. stop named instance ,run every 15 minutes

4. start named instance ,run every 20 minutes

After each stop/ start mirrored db very quickly synchronized .

I want to test break of mirror db when synchronization no longer possible

any suggestions ?

We want to place 70 GB db in mirror 300 km away and I want test everything

All possible break scenario

I didn't understand your question completely "I want to test break of mirror db when synchronization no longer possible". However, the following document describes quite a few test scenarios for database mirroring, and may be helpful.

http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

I need to restrict [database].MDF file's using on other MSSQL server. HELP!

Hi.
I have a database named SUTDNet on a server on my computer. I created
a few users for this database and i restricted any one's interests for
this database. However, i can't hide my database's datas when anyone
copies SUTDNet.mdf database file from my computer and attaches this
file on other server on other computer. The thief of data file can
enter my computer. When it goes, all user rights for the database on
my server are ineffective on other server.
How do I keep my datas from a theft like copying my data files.
Really appreciate any help and advice offered. Thank you.
Regards
Orgil.Orgil
Please do not multipost.The question has already answered in .programming
group.
"Orgil" <orgilhp@.yahoo.com> wrote in message
news:1174539323.344840.89960@.d57g2000hsg.googlegroups.com...
> Hi.
> I have a database named SUTDNet on a server on my computer. I created
> a few users for this database and i restricted any one's interests for
> this database. However, i can't hide my database's datas when anyone
> copies SUTDNet.mdf database file from my computer and attaches this
> file on other server on other computer. The thief of data file can
> enter my computer. When it goes, all user rights for the database on
> my server are ineffective on other server.
> How do I keep my datas from a theft like copying my data files.
> Really appreciate any help and advice offered. Thank you.
> Regards
> Orgil.
>