SQL - How to backup SQL database and run query from command line

If you need to backup SQL database and you have not SQL Management Studio you can do that through command line:

SQLCMD -S SqlServerName\SqlInstanceName

BACKUP DATABASE VeeamBackup TO DISK = 'C:\BackupDB2016.06.09.bak'

quit

If you need to run sql script you can proceed in this way:

SQLCMD -S SqlServerName\SqlInstanceName -i C:\temp\sqlscript.sql -o

C:\temp\sqlscript.txt

SQL management Studion download you can review this veeam article where I copied and paste text:

https://www.veeam.com/kb1761

You can get SQL Management Studio here:

2014: http://www.microsoft.com/en-us/download/details.aspx?id=42299 (MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe)

2012: http://www.microsoft.com/en-us/download/details.aspx?id=29062 

2008 R2: http://www.microsoft.com/en-us/download/details.aspx?id=22985

2008: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en

2005: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

An official Microsoft blog below shows step by step guides on performing this install:
http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx