Regular Database Backup Using Mssql

Environment

Hardware: Dell Server

Virtual Machine: VMware ESXi 3.5

Database: MSSQL2005

Operating System: win2003 sp2

Computer Name: taige_server

Two servers in the LAN have synchronized replication of the p2p topology, that is, the Hot Standby function. However, they are still worried about data security issues. Therefore, regular automatic database backup is implemented.

To put it simply, it is to create a maintenance plan.

1. Create a maintenance plan, name it 'db _ Bak', and select the 'backup database' task from the toolbar,

2. Select the database, expiration time, and backup directory on the properties page. Here I select a partition on the network storage to improve the disaster tolerance capability. Of course, you can also back up the data in the local directory.

3. After saving, you can view the new 'db _ Bak in 'job' in 'SQL agent. subpan_1, which is named after your maintenance plan, is easy to find.

4. Right-click the job and select 'properties' to show the detailed settings. On the left-side menu bar, select scheduler. Choose "new"> "name"> "run" (daily, weekly, or monthly)> "Run Time"> "duration ".

5. Confirm and confirm.

 

The above description is a bit cool. It's okay to familiarize yourself with the application.

See the picture.