Create SQL Server Project from Backup

An SQL Server Project can be created from a backup by:

1. Selecting Project > Create SQL Server Project from Backup from the main menu bar to launch the Restore Wizard utility.

   Note:
   The utility is designed to run on the computer that the SQL Server is installed on. All the paths provided by the user must be to physical drives on the computer and not to mapped drives.

   

2. Select the backup file by either completing the field manually or by clicking Browse to display the Select Backup File window.

   

3. Navigate to, and highlight the required file and then click Open to return to the Restore Wizard utility. The field will be populated with the selected file.

4. Click Next.

5. The next screen of the wizard is used to choose where the project is to be restored to, and enter authentication details.

   

6. Complete the Server Name and Database Name fields with the required details.

7. In the Authentication section, select either Use Windows Authentication or Use SQL Server Authentication as required.

8. Clicking Use SQL Server Authentication activates the User Name and Password fields which the user must then complete with valid SQL server login details.

   

9. Click Next.

10. The next screen is used to specify the restore options

    

11. Complete the Data File path and Log File path fields.

    Note:
    If the path is the same for both fields, complete the Data File path field only. The Log File path field will automatically default to the same path.

    Both fields can be populated manually or by clicking the button to the right of the fields to display the Browse for Folder window, enabling the user to navigate to the required path.

12. When both fields are populated, click Finish to complete the restore. When the restore is complete a message is displayed in the bottom-left corner of the Restore Wizard utility window, as follows: