SQL Server database backup methods

Source: Internet
Author: User
This article describes how to back up databases in sqlserver. For more information, see this tutorial.

This article describes how to back up databases in sqlserver. For more information, see this tutorial.

Copy backup only


I think a very useful feature is to copy only the backup, which allows you to copy the backup without disrupting the order of other backup files during the backup process.

Bay. When using SQL Server 2000, if you run a special full backup in the middle of a day, you must use full backup for recovery.

And all transaction logs that occur after the full backup. This new feature allows you to create a copy for backup only, and then use normal full copy

Achieve the purpose of recovery.


There is no change in the processing method of different backups. For transaction log backup, you can also copy the backup only-this is also not required

Disrupt the order of other backup files. Any backup created using this option is marked as copy_only in the backup table.


Partial backup


You may think that some backups are the same as differential backups-but they are different. Partial backup refers to all file groups except those marked as read-only files.

Back up data outside the group (unless specified. For read-only databases, only basic file groups are backed up. If you have a lot of static

Data, so using this method to back up your database is much faster.

Back up database

Method 1:

1. Stop SQL server (right-click the SQL server in the taskbar and select "MSSQLServer-stop ")
2. Find the data folder under the installation directory (default path: C: Program Files installation directory database name directory Data)
3. Copy the eonedbx_Data.mdf and eonedbx_Log.ldf files in the data folder.
4. Save the copied file to a secure drive letter.
5. Start SQL server

Method 2:

1. Microsoft SQL Server Enterprise Manager-> Expand "SQL server group"-> Expand "Database"
2. Right-click the database to be backed up and choose all tasks> back up the database. The "SQL server backup" dialog box is displayed.
3. Click the "General" tab and enter the backup name.
4. Under the "backup" column, click the "database-full" option.
5. Click the "add" button under the "purpose" column-> Add an existing or new backup device in the pop-up dialog box, or click "delete" and press

Delete A device from the backup device list.
6. Under "Override", click "APPEND to media" to append the backup to an existing backup, or click "Override existing media"

The backup is overwritten by an existing backup.
7. Click "OK"
Backing up ms SQL databases is so simple

Command Method

Backup database Company to disk = 'd: backup1.bak -- temporary Device
/* If no explicit path is specified here (for example, backup database company to disk = 'backup1. Bak '),
The backed up database will be automatically backed up to the directory specified by the system:
C: Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackup */

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.