...
Backup and restoration plans should be developed that protect the content and availability of these databases. SQL Server has various recovery models with the two common models being Simple and Full. The Aptify applications do not require a specific recovery model, but the recovery model should be well thought out and selected based on the business needs for data protection and availability. If the Full recovery model is used, a robust restoration plan can be developed that uses a database and transaction log backups that allow recoverability to point in time or point of failure with minimal or no data loss. A source for SQL Server information are is the Microsoft Books Online documents, such as Backing Up and Restoring Databases in SQL Server (http://msdn.microsoft.com/en-us/library/ms187048(v=SQL.100).aspx).
...
The SQL Server system-level databases, master, model, and msdb , are not specific to Aptify , but are essential for the operation of a server instance. It is recommended that the content and purposes of the system databases be reviewed and database backup and restoration plans developed for the system databases. See the Microsoft Books Online document Back Up and Restore of System Databases (SQL Server) (http://msdn.microsoft.com/en-us/library/ms190190.aspx).
| Note |
|---|
It is also recommended that the SQL Server Service Master Key be backed up as part of a complete SQL Server backup and restoration plan. The Service Master Key is the key at the root of all encryption , and needs to be protected. See the Microsoft Books Online document BACKUP SERVICE MASTER KEY (Transact-SQL) (http://msdn.microsoft.com/en-us/library/ms190337.aspx). |
...
On the Aptify Presentation Layer, if the e-Business or Aptify LMS applications are implemented, the directories here these Web Services are installed should be backed up. For e-Business, an example location might be C:\Program Files (x86)\telerik\Sitefinity 7. For LMS an example location might be C:\inetpub\wwwroot\courses.
...