SQL backup restore, detach append

Backup, restore, detach, attach

Backup: Right-click on the task on the database to be backed up and select Backup. In the Punch-in dialog box, select as needed. Note: The backup expiration time cannot be 0, or it will expire immediately. The target can be placed in any position as needed. Finally, click OK and the backup is successful.

Restore: Right-click on the database to select Restore Database, write a name on the target database that is not the same as the other database, locate the MDF file of the database you want to restore in the source device below . Finally, click OK to restore the success.

Detach: Right-click on the task on the database to be detached, select Detach, tick Delete link, click OK, detach successfully.

Attach: On the database right click Attach, in the Open dialog box click Add, find the database to attach the MDF file, click OK two times.

SQL backup restore, detach append