Home | Windows | Network | Interview Questions | Database | Virtualization | Knowledge Base | Contact Us

Related Links

Windows Home

Network Home

Database Home

Interview Questions

Win. Int. Q & A

Network Int. Q & A

SQL Int. Q & A

Knowledge Base.

Cisco VOIP

Windows 2003 KB

Windows 2008 KB

Win 2003 - IIS 6.0

SQL Failover Cluster

RAID Levels

RPC Guide

Configuring New Domain

CCNA Topic

IP Addressing

Subnetting

Cisco Career Path

Active Directory Trust

AD History



 

 

How to Backup Database SQL Server

How to Backup Database in SQL Server using Enterprise Manager Maintenance Plan Wizard

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.

6. Click Next. The Database Integrity Check dialog box appears.

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.

HTML Comment Box is loading comments...

Home | Windows | Network | Post Ur Issues | Database| Knowledge Base | Contact Us

Designed by TechieBird