Using sqlcmd to backup, copy and restore sql server databases locally. & sqlcmd -S Server -Q "BACKUP DATABASE [Database] TO DISK = N'C:\Path\Database.bak' WITH ...

Often overlooked, it's a powerful tool that can make your life a lot easier. Especially now that Microsoft has updated its functionality. It is safe to say that the command line tool sqlcmd has not ...