1. Open SQL Enterprise Manager.
2. In the console tree under Microsoft SQL Servers --> SQL Server Group --> DB_Server Name --> Management, right-click Database Maintenance, then select New Maintenance Plan.
3. When the Database Maintenance Plan Wizard appears, click Next.
4. In the Select Databases dialog box, select These databases, then select the user database and deselect the system databases: master, model, and msdb. The name of the user database is the name of the Backup_test database. The default name of Backup_test databases is Backup_test_, where is the name of the Backup_test server.
5. Click Next. The Update Data Optimization Information dialog box appears.
- Select Reorganize data and index pages.
- Select Change free space per page percentage to, and type 10 as the percentage.
- Select Remove unused space from database files.
- Schedule the data optimization tasks to execute during off-peak times. Click Change to change the default schedule.
7. Select Check database integrity and Perform these checks before doing backups.
8. Click Next. The Specify the Database Backup Plan dialog box appears.
9. Schedule the database backup tasks to execute during off-peak times. Click Change to change the default schedule
10. Click Next. The Specify Backup Disk Directory dialog box appears.
11. Select Use the default backup directory.
12. Click Next. The Specify the Transaction Log Backup Plan dialog box appears.
13. Select Back up the transaction log as part of the maintenance plan and Verify the integrity of the backup when complete.
14. Schedule the transaction log backup tasks to execute during off-peak times. Click Change to change the default schedule.
15. Click Next. The Specify the Transaction Log Backup Disk Directory dialog box appears.
16. Select Use the default backup directory.
17. Click Next three times. The Completing the Database Maintenance Plan Wizard dialog box appears.
18. Click Finish.
Thanks
R.karthikeyan
No comments:
Post a Comment