Showing posts with label northwind. Show all posts
Showing posts with label northwind. Show all posts

Friday, March 23, 2012

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

Monday, March 19, 2012

I want the Northwind Script !

Hello,

I'm a new user here ,

i want the script"query" for Northwind database

wich create tables and inserting the data

wait your help ?

You can download The Northwind database and script from here: http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en. After downloading SQL2000SampleDb.msi, xtract the sample database scripts by double-clicking SQL2000SampleDb.msi. SQL2000SampleDb.msi will extract the database scripts and this readme file into this default folder:
C:\SQL Server 2000 Sample Databases.

Regards,

Gail

I want the Northwind Script !

Hello,

I'm a new user here ,

i want the script"query" for Northwind database

wich create tables and inserting the data

wait your help ?

You can download The Northwind database and script from here: http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en. After downloading SQL2000SampleDb.msi, xtract the sample database scripts by double-clicking SQL2000SampleDb.msi. SQL2000SampleDb.msi will extract the database scripts and this readme file into this default folder:
C:\SQL Server 2000 Sample Databases.

Regards,

Gail