Tutorial: two simple implementation methods for server data backup

Method 1:

1. Stop SQL server right-click the SQL server in the taskbar and select "MSSQLServer-stop ")

2. Find the default path of the data folder under the installation directory: C: Program FilesRongbo student status management system Server 1.0 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. Start> program> Microsoft SQL Server> Enterprise Manager> SQL server group> Database"

2. Right-click "eonedbx" database-> point to "all tasks"-> click "Back up Database". The "SQL server backup" dialog box is displayed.

3. Click the "General" tab and enter the backup name in the "name" text box.

4. Enter a description)

5. Under the "backup" column, click the "database-complete" option.

6. Click the "add" button under the "purpose" column-> Add an existing or new backup device in the pop-up dialog box, or click the delete button to delete a device from the backup device list.

7. Under "Override", click "APPEND to media" to append the backup to an existing backup, or click "Overwrite existing media ", to overwrite an existing backup.

8. Click "OK"

Related Articles]

1. The survey shows that the virtual server backup success rate is less than 60%.
2. Server data backup method