Question Backup Database MS SQL Server by Command Line in windows

[esfahanhost]

Hi

i use this command for backup MySQL Database in Plesk Obsidian and Windows Server 2016 :

cd C:\Program Files (x86)\Plesk\mysql\bin
mysqldump.exe -uMyUsername -pMySamplePassword -P3306 SampleDatabse > D:\BACKUP\MySQL\SampleDatabse.sql

BUT i can not find command for Get Backup ( MS SQL Server ) Database by Plesk Command Line

Also Thanks if support me by a command for restore this backup By Command Line

Please Help Me

Thanks

 

[iForced]

You can check this website for the restore question via commandline : How to backup and restore MySQL databases using the mysqldump command or you can use phpmyadmin

 

[esfahanhost]

You can check this website for the restore question via commandline : How to backup and restore MySQL databases using the mysqldump command or you can use phpmyadmin

Your Answer is for MySQL Databases , But i need for MS SQL

 

[iForced]

I’m sorry, I did understand it wrong. Take a look at this : Back Up and Restore of SQL Server Databases - SQL Server or Backup-SqlDatabase (SqlServer)

You could also use backup software like Veeam (also a free version) or SQL Backup & FTP etc for more control

 

[esfahanhost]

i find this solution for get backup MS SQL SERVER by Command Line ( CMD )

Open CMD =>

sqlcmd -S Your_server_and_instance -Q ""BACKUP DATABASE [DatabaseName] TO DISK='C:\YourFolder\BackupFile.bak' WITH INIT""

Example if database is default in the server :

sqlcmd -S localhost -Q ""BACKUP DATABASE [New_Shop] TO DISK='C:\New_Shop.bak' WITH INIT""

OR

Example if database have instance name or you have several database in the plesk :

sqlcmd -S .\MSSQLSERVER2016 -Q ""BACKUP DATABASE [New_Shop] TO DISK='C:\New_Shop.bak' WITH INIT""

Have a good time

masoud saeidi

www.esfahanhost.com