sqlcmd -E -S localhost -i RunBackup.sql -o Backup.log I have simplified this example for brevity, but it's a straightforward example of how sqlcmd could be used to automate simple code.