I am going through the backup wizard and I see a page called the "Attach files".What is that? (98664)

I am going through the backup wizard and I see a page called the "Attach files".What is that?

You can use this option to store selected files with the backup.

This feature lets you bundle items with the backup file that may be necessary to restore it. LiteSpeed appends the files to the data section of the backup file, and consequently the attached files are encrypted and compressed with the backup if those options are selected.

Some examples of when to use this feature include the following:

* Extended stored procedures packaged in DLLs may exist outside of the database, but you may need them to restore it. These external DLLs can be attached to the backup file.
* If you are going to upgrade a database application, you can back up the database along with the current version of the application. If anything goes wrong during the upgrade, you can restore both the database and the related application files.
* When sending a backup file offsite to another person (such as an auditor or consultant), you can attach schema diagrams, username and password lists, instructions, and other documentation.

To retrieve the attachment, select Restore Attached Files and Directories on the Attach Files page of the Restore wizard. You can also use xp_restore_attachedfilesonly. See xp_restore_attachedfilesonly for more information.

Tip: To restore attached files only using the Restore Wizard, right-click a database in the server tree and select Restore | Attached Files...