How the database server is backed up

Database server due to the large amount of data and very important, every loss of data, can be a great loss. So in the actual operation of the process who does not have the full protection of data without loss of damage, then this credit data backup is very important. Then server backup is a pointer to the data generated by the server for the corresponding storage backup process, so as to ensure the safe operation of data. Hong Kong Kwai Fong Engine Room today, SQL database server backup as an example to share the backup skills.

Database Server Backup Tips One

1. Start-Up Program->microsoft SQL Server, Enterprise Manager, expand SQL Server Groups, expand Databases;

2. Right-click the "eonedbx" database, point to "All Tasks", click the "Backup Database" option, and the "SQL Server Backup" dialog box appears;

3. Click the General tab, and in the Name text box, enter the name of the backup;

4, enter "description" (can skip);

5, in the "Backup" column, click the "Database-full" radio button;

6. Under the "Purpose" column, click the Add button, add an existing or new backup device in the popup dialog box, or click the "Delete" button to remove a device from the list of backup devices;

7. Under "Rewrite", click "Append to Media" to attach the backup to the back of an existing backup, or click "Overwrite existing media" to re-overwrite the backup on top of an existing backup;

8. Click "OK".

Database Server Backup Tips II

1. Stop SQL Server (right click on the SQL Server server in the taskbar and select "mssqlserver-Stop");

2. Locate the Data folder under the installation directory (default path: C:\\Program);

3, copy the Data folder under the two files Eonedbx_data.mdf and eonedbx_log.ldf;

4. Save the copied file to a secure drive letter;

5. Start SQL Server.

Isn't it easy and easy? But it is such a simple operation, you can make the database server backup more secure, so it has not been set, as soon as possible to set up a bit.
Hong Kong Kwai Fong Room, owned property, self-built computer room, with all the mainstream operators in Hong Kong bandwidth line, IP resources, the room provides 7x24 hours of after-sales service, professional and technical personnel around the clock in the machine room standby, timely to solve all aspects of technical problems for customers. Welcome to Contact QQ2851041311 Tel: 18376476276
Kwai Fong-Xiao Wang

How the database server is backed up