I dont have much experience with standard edtion.Yes i need sysnchronous without witness but when the principal is down how the mirror side we can make as principal and accessible...

Ok.Can you please guide to setup a asynchronous type mirroring because when i use the database mirror iwzard to set up mirroring the asynchronous option is disabled.

Thank You Susan

I want to set up mirroring in synchronous mode.There is not witness.I am using sql server 2005 standard edition sp2

Thank You

Susan

Import wont allow dulpicates in the primary key column

Regards

Susan

,10Yes i have same data in all table for example.The old database have table 1 with primary key values as 1,2,3,4

New database table 1 with primary key values as 1,2,3,4,5,6,7,8,9,10

So...

Hello,

The database is a well structured one with 88 tables and perfect constraint relationships.Most of the Primary keys are numeric columns.So whether i have to create...