Wednesday 16 February 2011

Microsoft SQL Server protection


Every business has mission critical applications and data. Therefore, it is very important to keep servers up and running all the time 24 X 7. In today’s world there is a need to store and process terabytes of data and it is vital to make this data highly available.

High availability is all about your site, database or email being accessible all the time. High availability solutions minimise the downtime for these mission critical applications, such as SQL, Exchange or IIS.

Microsoft SQL Server is a powerful database used to store and maintain data in businesses of various levels, be they small, medium or large. As such loss of a MS SQL server can have a huge impact on business operations.

Our consultants can take you through pre and post installation concepts and common issues you come across while working with SQL Server. We can help answer common question like what is the best concept for you? What should you use?

1.    Database mirroring?

2.    Log shipping?

3.    Clustering?

4.    Or just real-time replication.

Business Data is the core of your business and as such it should be protected. If you are business owner you should be asking yourself; how much time can the business afford without access to critical data or emails? How much money could I lose if my website, ordering system was down? Depending on the type of business you may also want to check if you have any service level agreements you could fail to deliver due to systems being down.

If you are the IT administrator you will be worried about getting the systems up and running again. Your main pain point will be how quickly can I get this server back online? The answer is days if you are using tape backup and minutes if you are using a failover solution.

Although in this blog I have covered Microsoft application we can cover Linux applications and also bespoke Microsoft or Linux applications.

If you have a project like this coming up please feel free to give Open Minds a call on 0121 533 7178.

1 comment:

Raj said...

Database administrator can avoid data loss from sql server database by maintaining regular data and log backup. Microsoft also offers an inbuilt command to check the database consistency that is DBCC CHECKDB command to check and repair corrupt sql server database. In case, no any backup is available then third party sql recovery software can help to recover sql server database.