Network & server issues

IBM BladeServer
SQL Server
We are a retail company dealing with textile , retail business. We have about 4 branches within the span of around 250 to 300 kms from our main office. In a branch we have about 60-70 computers with thin clients operating with the help of IBM BLADE server. Total, we have about 250-270 computers accessing the server. The server is about 5 years old and in these 5 years everything was good except a few server and network issues because of which we had to go for manual billing and other processes and also it causes severe problems though the n/w and server errors occur for few minutes. Our main usage of server is at point of sale , admin and accounts department. Now we have an option to go for offline application which we could use at the time of main server faults and we have to merge the data from the offline app to main server DB everyday night. Is it the good decision or can we go for a sub-server which could be used during n/w or server connection failure? Will the sub server concept be cost-effective and what would be the performance of it? Please help us with your valuable solutions.

Software/Hardware used:
IBM blade server,SQl serwer2008

Answer Wiki

Thanks. We'll let you know when a new response is added.

It sounds like you need to look into some sort of high availability solution.  With SQL Server 2008 you can look at database mirroring which would handle all the resyncing of data between the primary and secondary server automatically when the failed server comes back online.

There’s a wealth of information available on the net about database mirroring.

Discuss This Question: 2  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • mshen
    I would use the Offline application which syncs when online again.  This is very similar to how Microsoft Outlook works with the offline cache.  I assume your POS vendor will hand you a large quote to make those modifications if the feature isn't already built-in to the software. As for database mirroring, it will require more hardware, licensing, security, and possibly a faster WAN connection.  You would have to turn one of your location into a full blown backup site.
    27,385 pointsBadges:
  • Colin Smith
    If you choose to use a sub server, then you might need to look at replication. Mirror will work as well but the sub server would only be available to write to if it is the Primary at the time. So if the main server is usually the primary and it fails, then you can make the secondary the new primary and you will be able to write to it. Many options are available and you will need to research the many different models of HA that SQL Server has available and find the one that best fits your specific situation. As with everything in the database world, the answer is it depends.
    945 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: