Article ID: 120718, created on Mar 25, 2014, last review on Jul 25, 2016

  • Applies to:
  • Plesk 12.0 for Linux
  • Plesk 11.5 for Windows


How to create MS SQL database backup manually?


  1. Use the SQLCMD utility.

    • Find the host name to be used:

      "%plesk_bin%\dbclient.exe" --direct-sql --sql="select host from databaseservers where type='mssql'"

      In this case the name to use is .\MSSQLSERVER2012

    • Open cmd utility, go to the Tools\Binn directory of the Microsoft SQL server installation:

      cd "C:\Program Files\Microsoft SQL Server\100\Tools\Binn"
    • Use the following command to backup desired database:

      SQLCMD.EXE -E -S .\MSSQLSERVER2012 -Q "backup database sample_database to disk = 'C:\sample_database_backup.sql'"

      where sample_database is the database name, C:\sample_database_backup.sql is full backup name

  2. Use SQL Management Studio. Please find the instructions how to backup database here.

  3. Use Plesk GUI: Subscriptions -> domain.tld -> Websites & Domains -> Backup Manager -> Database Backup. Select database you want to backup.

NOTE: If you want to restore database on another server download backup in Plesk and upload it on destination server through GUI in Plesk Backup Manager -> Database Backup.

Search Words

mysql connect

sql database backup using command line utility

Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo

Unable to dump MS SQL database

sql backup

sql command utility

iis issue

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 46a8e394d6fa13134808921036a34da8 85a92ca67f2200d36506862eaa6ed6b8 bd7fc88cf1b01f097749ae6f87272128 29d1e90fd304f01e6420fbe60f66f838 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7

Email subscription for changes to this article
Save as PDF