| By using an online backup provider, you can easily | | | | replicate your data to other servers running SQL |
| backup your valuable SQL server data through | | | | Server, in order to backup your database. This |
| snapshot replication, transactional replication, or merge | | | | process allows you to replicate your data to another |
| replication. | | | | server at your company location, or via the Internet |
| It is vitally important that every business have a | | | | to a SQL server hosted by an online data backup |
| disaster recovery plan for its electronic data stores. | | | | provider. |
| Your company's data includes more than simple Word | | | | If your local server should fail, you will have the ability |
| documents and e-mail messages; it also includes you | | | | to restore it from one of your replicated copies and |
| databases and web site information. | | | | quickly get your database back up and running. |
| One of the worst things that can happen to your | | | | Microsoft SQL Server offers three types of SQL |
| business, whether it is large or small, is to lose any of | | | | replication. They are: merge replication, snapshot |
| your electronic data due to hardware failure, | | | | replication and transactional replication. |
| software corruption, or even to a natural disaster. | | | | Snapshot replication simply copies all database |
| Unfortunately each of these three things happens | | | | objects exactly as they are at any given moment in |
| more than you might want to think about. But, by | | | | time. |
| being prepared you can be one step ahead of the | | | | Transactional replication copies changes to the |
| game. | | | | database as they happen in real-time. |
| If you company uses an SQL database, it is vitally | | | | Merge replication first completes a snapshot |
| important that you have regular backups of the | | | | replication and then follows it with transactional |
| data. The best practice for any company is to have | | | | replication as data changes. |
| a local copy of the data as well as offsite backup in | | | | SQL Server allows you to easily configure it to |
| case of any major disaster to your physical building. | | | | perform each of the three SQL replication methods |
| One of the best things you can do with your SQL | | | | over the internet. This allows for you to be able to |
| data is to replicate the data to a backup server as | | | | backup your data online just incase you ever need to |
| well as an offsite backup location. This will ensure | | | | restore it. The minimum acceptable backup would |
| that your data is available should you ever need to | | | | be a snapshot replication each night. |
| restore it and there is some form of damage to your | | | | One of the most important things for your business |
| servers. | | | | success is its electronic data. The data your |
| By having a local copy you can do simple | | | | company generates each day has already cost your |
| restorations, and by having an offsite copy, you are | | | | company both time and money. Trying to recreate |
| covered in case something happens to your building. | | | | data is not what you, as a business owner, ever |
| Microsoft SQL Server allows you the ability to | | | | want to have to do. |