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.