database mirroring / database replication.

Lost User

Hi all In c# forum i asked the below question

Hi all

Please clear my doubt.
I have one server system where i installed sql server.
5 client machines accessing that.
now suppose if there is any power fluctuation like it's coming for 5 min and again going and so on.
So for this kind of situation, how to save the data or how to update the database each second.??
Is it possible that at a time we update the client database also and server database also.?
i.e at button click it should update both client and server database..

Please help..

Then i got the suggestion of database mirroring / database replication. I am very much new to this. Please need suggestion from you guys.

jschell

Code-Hunt wrote:

Please need suggestion from you guys.

Google the topic. And buy a book or perhaps two. Then set up some test servers. And test it. After you figure out the pro/cons of the possible different ways to do this. Naturally of course would also need to consider other types of failures, which means that you need the two server located in different geographic areas. That of course means you must not only consider the methodology of replication but the cost. And find hosting companies to host at least on of the servers. You must also test it and insure that the servers continue to run in production. With the cost you might also consider the possibility that doing all of this yourself might not only cost a lot (if you are being paid) but will also have a high risk. Consequently finding a hosting service that provides all of the above but be more effective.

Jorgen Andersson

Get a UPS[^] for all affected systems including switches.

Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln

Mycroft Holmes

And what sort of answer is that, it has nothing to do with databases, he did not ask for a solution to his problem he wanted to know about mirroring :doh: I feel like an idiot for not thinking of that!

Never underestimate the power of human stupidity RAH

Lost User

Code-Hunt wrote:

now suppose if there is any power fluctuation like it's coming for 5 min and again going and so on. So for this kind of situation, how to save the data or how to update the database each second.??

That cannot be solved by software, you'll need an UPS. It's simple; if the power to your server is cut when it is writing, the system might die and no longer boot.

Code-Hunt wrote:

So for this kind of situation, how to save the data or how to update the database each second.??

That'd hardly help; how long does your server take to boot? You reckon' it had time to rollback a failed transaction?

Code-Hunt wrote:

Is it possible that at a time we update the client database also and server database also.?

Yes. Take your IDbCommand-code (the block where your C# is executing the SQL), and press Ctrl-C and Ctrl-V. Simply execute every command twice, once to your server, and a local copy.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

Jorgen Andersson

I believe someone didn't get the sarcasm, (over)compensating.

Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln