Slime: SQL Server 2005 database backup and Recovery

This article by show according to Lin Feng to provide friendship sponsorship, starting in the mud row world.

Server, because the business uses a database that is SQL Server 2005, it is necessary to back up the database first.

Backups can be broken down into manual and automated backups, and we'll start with manual backups.

Open SQL Server Management Studio, click the database you want to back up-tasks-backup, such as:

In the disk option, select the disk on which you want to store the database backup files, such as:

After the above operation, we click Finish, the database will start to backup, such as:

We can see that the database has been backed up and the backup file is stored in the TestDB directory on the E drive.

The above is a manual backup of the database, below to configure SQL Server automatic backup.

Attention:

1. Automatic backup of SQL Server 2005 must have the Intergration services component installed. Otherwise, SQL Server 2005 cannot perform job creation.

2. Automatic backup of SQL Server 2005 requires support for the SQL Server Agent service, and the service must be started with the system.

Click "Manage"-"maintenance Plan"-"Maintenance Plan Wizard", such as:

Name in accordance with their actual situation to fill in. The server default is native if you want to back up the SQL Server database on the other server in the native computer. You can also do the following.

If you are backing up a database on another server, verify that you must select Use SQL Server Authentication.

maintenance tasks, we select "Back Up Database (full)"

This is the order of the specified tasks, at this time there is only one, so we choose the default.

Select the database to back up

Select a target location for database backups

Configure the execution time and other information for the schedule

Configure the execution cycle for this schedule at this time

Once configured, we can see that there is one more database backup schedule in the Maintenance Plan option and one more database backup job under the Jobs option. Such as:

In order to see the actual effect, we now execute the job directly, such as:

You can see that the database is now backed up properly.

The above is a backup of the SQL Server 2005 database, let's restore the database.

Copy the backed up database files to the server where you want to recover the data, such as:

Create the required databases on the new server, such as:

If you have the same name on the new server as the database on the original server, it is strongly recommended that you select Overwrite existing database in the options card. Such as:

You can see that the database has been restored correctly, such as:

This completes the backup and restore experiment for the SQL Server 2005 database.

I'll be in the next article about SQL Server 2005 Backup and restore the database in the form of a file.