asked on DOS Batch File to backup a SQL Database
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.ba
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. :-)
I can easily run a db backup in SQL Management Studio Express:
BACKUP DATABASE [LivingTreasures] TO DISK = N'C:\Data\SQL\Backup\lt.ba
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. :-)
Microsoft SQL Server 2008
Last Comment
SOTA
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Awesome, got it to work perfectly. I then used 7 ZIP to compress it!!!
Life is good again. :-)
Life is good again. :-)
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.