Publishing to Specified Server Publishing to the specified server allows you to select a target Microsoft SQL Server machine to which you can publish your databases. To publish data, do the following: Launch the Publish Database wizard. Specify a restore point. Fine-tune the restore point. Specify the target server. Review the publishing summary.