ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Course Of The Month
8 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
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.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. :-)
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
3 Comments
Active today
Found a post here that claims it works:
http://www.howtogeek.com/50299/batch-script-to-backup-all-your-sql-server-databases/
You can pass username and password by:
sqlcmd -U sa -P pwd
If you don't like the inline command as per the example you could use an input file:
sqlcmd -U sa -P pwd -i c:\backups\my_backup_scrip
Other parameters:
-S parameter passes server name
-d parameter passes DB name
Would highly recommend against putting the sa password in a script like that though for security purposes.
Have not tested this myself though.
As an aside, why do you want it in a script like this ? If for automatic scheduling, why not use a maintenance plan / SQL Serve Agent ?
http://www.howtogeek.com/50299/batch-script-to-backup-all-your-sql-server-databases/
You can pass username and password by:
sqlcmd -U sa -P pwd
If you don't like the inline command as per the example you could use an input file:
sqlcmd -U sa -P pwd -i c:\backups\my_backup_scrip
Other parameters:
-S parameter passes server name
-d parameter passes DB name
Would highly recommend against putting the sa password in a script like that though for security purposes.
Have not tested this myself though.
As an aside, why do you want it in a script like this ? If for automatic scheduling, why not use a maintenance plan / SQL Serve Agent ?
Thanks, I will try to get this to 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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:
Each Login (Windows or SQL)
* Its Server Roles
* Every database to which the login is mapped
* The associated "Database User" for this …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Suggested Courses
Course of the Month8 days, 5 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
729 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.