| Anchor | ||||
|---|---|---|---|---|
|
...
Greenstone recommends that customers backup their MSSQL databases on a regularly scheduled basis. The SQL Server Maintenance Plan found inside SQL Server Management Studio allows the customer to configure their own Maintenance Plan to meet their business requirements.
The content below provides a recommendation for performing regularly scheduled backups. This recommendation should not be considered a requirement. This template should be modify based on business requirements and used as a guideline to assist your I.T. team in deploying a plan that meets your company's needs. The details of a SQL Server Maintenance Plan may vary from customer to customer. There are many unique situations that should be considered when creating a SQL Server Maintenance Plan. If your business has a Database Administrator, it is best to discuss Database Backup schedules and Recovery capabilities to ensure all relevant data is backed up on a regular basis and can be recovered in a timely manner if necessary.
Maintenance Plans allow the administrator to create backups, perform database integrity checks, database statistics updates and other tasks. These tasks are part of a Subplan which can be scheduled to run at specified time intervals.
Best Practices
http://sqlmag.com/database-backup-and-recovery/sql-server-backup-best-practices
Perform Full Backups Daily
Perform Frequent Transaction Log Backups
Regularly Back Up System Databases
Back Up the Host OS Daily
Practice Recovery Operations – It is important to perform an actual Database Recovery operation to verify the backup and restore processes are working properly.
There are 2 methods for creating a Maintenance Plan via Microsoft SQL Server Management Studio -> Management
...