How do I only backup databases in Plesk?

I have Plesk Onyx Version 17.8.9 on a Windows 2016 server.

I would like to use the Plesk Backup Manager to ONLY backup all MS SQL 2016 databases within a Subscription. I do not want to include any site files, just the MS SQL databases. The backup options only allow for User files and databases but not just the databases.

If this cannot be done within Plesk then it would be appreciated if you can show how it can be done using other means such as a batch file command or from MS SQL Server Management Studio.
mike99cAsked:
Who is Participating?
 
Máté FarkasDatabase Developer and AdministratorCommented:
Simlest way to do this in Windows command line on the server with this command:
sqlcmd -Q "BACKUP DATABASE [PleskDatabase] TO DISK = 'C:\PlestDatabase.bak'"

Open in new window


You should replace PleskDatabase to the name of the database of Plesk on SQL Server.
Make sure that full path of the backup file is valid.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.