DOS Batch File to backup a SQL Database
Posted on 2012-12-31
Is there a way to run a DOS batch file that backups a single SQL database?
I can easily run a db backup in SQL Management Studio Express:
BACKUP DATABASE [LivingTreasures] TO DISK = N'C:\Data\SQL\Backup\lt.bak' WITH COPY_ONLY, NOFORMAT, INIT, NAME = N'LivingTreasures-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
But, now I want to have a batch file (backup.cmd) that can do this. Of course, it needs to connect to the db engine (SOTASERVER\SQL2008), supply password (sa/pw) and the db name (LivingTreasures).
High points for a speedy solution that will work. :-)