Whether a business is small, medium or large business, it must have a well-written plan for backing up the servers. Planning a backup strategy up-front and documenting not only the backup process but also the restore process, will save you a ton of time in the end. Because of its value to the company and the sensitive nature of it, the classification of data must be carefully considered in the planning stage. Based upon these classifications, the backup and restore plan will need to be tested and adjusted. While planning stage, data should be ranked according to sensitivity and value to the business.

With data that is highly valuable to a company, plans must include an increased backup frequency due to the nature of the costs incurred while recapturing data in case of a to disaster. Recoverability plans must also consider the availability requirements of this data. With highly sensitive data, plans must include encryption of backups, especially when this data is stored offsite.

With a SQL Server, DBAs should also be concerned with the OS, the applications that the server runs and finally the databases. In other words, the entire server needs a backup and recovery plan. User databases are critical to backup plan, but system databases that contain significant information like Users, SQL Jobs and other system functionality, must also be taken into account.

Source: http://www.bitpipe.com/detail/RES/1244574080_872.html?psrc=RLT

Site Powered by: BPO Services, Freelance Projects