This is an archive version of the document. To get the most up-to-date information, see the current version. Restoring Database Schema and Data To restore database schema and data, do the following: Launch the Restore wizard. Specify a restore point. Fine-tune the restore point. Specify target SQL server settings. Select database objects. Specify names for restored objects. Specify directory names for file tables. Specify additional restore options. Review the restore summary.