Click here to Skip to main content
15,900,973 members
Home / Discussions / Database
   

Database

 
QuestionPartial update via OleDBDataAdaptor Pin
Dan Neely27-Jun-07 3:12
Dan Neely27-Jun-07 3:12 
AnswerRe: Partial update via OleDBDataAdaptor Pin
Dave Kreskowiak27-Jun-07 5:19
mveDave Kreskowiak27-Jun-07 5:19 
GeneralRe: Partial update via OleDBDataAdaptor Pin
Dan Neely27-Jun-07 5:40
Dan Neely27-Jun-07 5:40 
GeneralRe: Partial update via OleDBDataAdaptor Pin
Dave Kreskowiak27-Jun-07 5:55
mveDave Kreskowiak27-Jun-07 5:55 
QuestionI want to secure my DB Pin
merwa27-Jun-07 2:35
merwa27-Jun-07 2:35 
AnswerRe: I want to secure my DB Pin
Vasudevan Deepak Kumar27-Jun-07 2:47
Vasudevan Deepak Kumar27-Jun-07 2:47 
QuestionSQL Server 2000 mirror Database Pin
AcDev727-Jun-07 1:01
AcDev727-Jun-07 1:01 
AnswerRe: SQL Server 2000 mirror Database Pin
Mike Dimmick27-Jun-07 2:24
Mike Dimmick27-Jun-07 2:24 
Database mirroring is a new feature of SQL Server 2005 (SP1 and later).

SQL Server 2005 database mirroring is based around log shipping. Clients connect to the Principal (active) node and submit their queries; data modifications are recorded to the transaction log on the Principal, which sends log updates to the Mirror (standby) node. In the asynchronous (high-performance) mode, the Principal reports success to the client as soon as the modifications are recorded to its own log, it does not wait for the Mirror to write to its log. In this mode, some updates can be lost on failure of the Principal node, if the corresponding log operations have not yet been recorded in the log.

In synchronous (high-safety) mode, the Principal waits for the Mirror to complete recording the modifications to its log before reporting success to the client, when committing the transaction. This causes a delay to the client as all the log records have to be transferred over the network and written to the log file. This prevents lost updates.

For automatic failover, a third node, the Witness, is required. This doesn't keep a copy of the database, it only informs the other two instances which it can see. If the Mirror and Witness can see each other but neither can see the Principal, the Mirror assumes that the Principal has failed and takes over the Principal role. The Principal, if it loses contact with both Mirror and Witness, takes its database offline.

The standard SQL Server 2000 high-availability solution is clustering. I would recommend investigating that before venturing into trying to implement your own solution. It may be possible to implement a manual 'mirroring' solution using Transactional Replication. I've not tried to do this.

Stability. What an interesting concept. -- Chris Maunder

GeneralRe: SQL Server 2000 mirror Database Pin
Colin Angus Mackay27-Jun-07 12:19
Colin Angus Mackay27-Jun-07 12:19 
GeneralRe: SQL Server 2000 mirror Database Pin
Mike Dimmick27-Jun-07 23:30
Mike Dimmick27-Jun-07 23:30 
QuestionStored procedure Pin
sidbaruah26-Jun-07 23:36
sidbaruah26-Jun-07 23:36 
AnswerRe: Stored procedure Pin
mamatha_raghu27-Jun-07 0:17
mamatha_raghu27-Jun-07 0:17 
AnswerRe: Stored procedure Pin
Pratik Vasant Shah27-Jun-07 19:44
Pratik Vasant Shah27-Jun-07 19:44 
Questionmysql input with stored procedure help Pin
boyindie26-Jun-07 23:20
boyindie26-Jun-07 23:20 
AnswerRe: mysql input with stored procedure help Pin
Devkranth Kishore Vanja28-Jun-07 20:42
Devkranth Kishore Vanja28-Jun-07 20:42 
GeneralRe: mysql input with stored procedure help Pin
boyindie28-Jun-07 21:48
boyindie28-Jun-07 21:48 
Questionsharing sql server without client installation Pin
mamatha_raghu26-Jun-07 20:41
mamatha_raghu26-Jun-07 20:41 
AnswerRe: sharing sql server without client installation Pin
Manas Bhardwaj26-Jun-07 22:24
professionalManas Bhardwaj26-Jun-07 22:24 
AnswerRe: sharing sql server without client installation Pin
originSH26-Jun-07 22:29
originSH26-Jun-07 22:29 
GeneralRe: sharing sql server without client installation Pin
mamatha_raghu27-Jun-07 0:06
mamatha_raghu27-Jun-07 0:06 
GeneralRe: sharing sql server without client installation Pin
originSH27-Jun-07 1:06
originSH27-Jun-07 1:06 
AnswerRe: sharing sql server without client installation Pin
Mike Dimmick27-Jun-07 2:46
Mike Dimmick27-Jun-07 2:46 
QuestionSequence of events/methods execuion in SSIS Pin
I.explore.code26-Jun-07 19:57
I.explore.code26-Jun-07 19:57 
Questionpull subscriptions Pin
SVb.net26-Jun-07 12:58
SVb.net26-Jun-07 12:58 
QuestionDatabase design for exam system? Pin
HinJinShah26-Jun-07 8:08
HinJinShah26-Jun-07 8:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.