What is database separation, attaching, backup, restore

Separation means disconnecting the database (but not deleting it, it still exists on your hard drive, so you can move the database around as you please).

The addition is the opposite of separation.

Backups are to prevent errors, and restore is to prevent data loss.

Backup is to back up the data in the local server, and the database can continue to be used during the backup process.

Restoring a database is restoring a database file that has been backed up.

Separation means disconnecting the database (but not deleting it, it still exists on the hard disk), which means that the database is deactivated, so that the database can be moved around at will.

An attached database is an attachment to a detached database file, and the effect of the attached database is the same as that of the restored database.

Difference Between Attach and Restore:

The attachment can be different hard disks or servers, such as SQL on this computer, and the database file is on another computer, you can use the attachment, so that the SQL program and the data file are separated, and the restore is usually on the same computer, at most different partitions. Attach can also be this is the id table, the other SQL is the content, or the content of different periods, for example, this year to add a new server SQL, put the new data in the new SQL, the old SQL data can be used in the way of addition. // you clear ？

Backup: Make a copy of the database.

Restore: Restores the database to a previous backup.

Detached: Separate the database from the mssql service that is stopped and run without using add-ons: load the detached database to the mssql service and be called normally.

If there is a backup. bak file, you can right-click to restore it.

How to do database restore:

Right-click on the database - Restore database - Add the path to the database file that needs to be restored.

In the Restore Source option you can select 'Source Database', 'Source Device'.

The Select Source Database tool automatically displays some of the previous backups of the database, and then directly selects the database backup set that needs to be restored.

Select the source device and click on the back. Add the database files that need to be restored.

There is also a way to attach a database.

Steps:

Copy the database files and log files that need to be attached to one of the already created folders.

Right-click the database object and choose the Attach command from the shortcut menu to open the Attach Database window.

In the Attach Database window, click the Add button in the middle of the page to open the window for locating the database file, and select the database file (suffix) you want to attach in this window. mdf）

Click OK to complete the setup of the attached database file, and click OK to complete the additional database task.

Open the database. Locate the database and right-click to find the add-on, click Enter. Then click Add to find the location where your database is stored, and you're good to go.

Right-click on the database and append it.

You can attach it, find 123, and you can attach it.

Right-click on the database and select Addend.

1. Data backup is to preserve the integrity of the data, prevent illegal key, power failure, virus infection, etc., so that the data is lost, if necessary, it is best to back up frequently to prevent data loss.

2. Data restoration: If the database is wrong or crashed, the original data will be restored.

3. Improve the availability and disaster recoverability of the system, and recover data when the database system crashes.

4. Using database backup to restore the database is the best solution to provide the minimum cost of data recovery when the database system crashes.

3. There is nothing without data, and database backup is a powerful means to prevent disasters before they occur.

Reasons: 1. Improve the high availability and disaster recoverability of the system, when the database system crashes, the data cannot be found without database backup;

2. Using database backup to restore the database is the best solution to provide the minimum cost of data recovery when the database system crashes, and if the customer is asked to fill in the data again, the cost will be too great;

3. There is no data without everything, database backup is a powerful means to prevent disasters before they occur.

Database backup is to back up your data to the hard disk, once the system has a problem, if you don't back up you will lose a lot of useful data, after the backup, even if you reinstall the system it doesn't matter, you can use data recovery to restore the data you need to your application software.

In order to prevent accidental errors or deletions of the database, the database is usually backed up and restored.

Separation means disconnecting the database (but not deleting it, it still exists on your hard drive, so you can move the database around as you please).

An attached database is an attached database file that has been detached.

Backup is a backup of the data in the local server.

Restoring a database is restoring a database file that has been backed up.