In this video, I have explained how to backup SQL Server database using Command Prompt.
Steps:-
1) Open command prompt.
2) Type following command in command prompt.
3) Hit enter.
SqlCmd -S BOSS-PC\SQLEXPRESS -U sa -P 1234 -Q "Backup Database MyDb_18122018 Το Disk='D:\Backup\MyDb_18122018.bak"
SqlCmd - It will use SQL server command tool.
-S BOSS-PC\SQLEXPRESS(It's SQL server name.)
-U sa (SQL server username)
-P 1234(SQL server password.)
-Q "Backup Database- It's SQL command MyDb_18122018(My database name.)
To Disk='D:\Backup\MyDb_18122018.bak" (Destination for storing database backup.)
Watch my YouTube video on same topic:-
