Restoring Multiple Databases To restore multiple databases to an on-premise Microsoft SQL Server machine, use the Restore wizard. Launch the Restore wizard. Select databases you want to restore. Specify a restore point. Specify the target server. Specify files location.