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
GO
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).
Help!
High points for a speedy solution that will work. :-)
The reason why I am not using a maintenance plan is because I need to export the dB to a web server to drive a website.
The person doing the export has no knowledge of SQL. Nor do I want her in there behind-the-scenes. Too dangerous!
So, if I can have her click a CMD file and have the export be done for her - that will help immensely.