O'Reilly logo

SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond by Tom Carpenter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Batch Files

At this point, you have either gained a fundamental understanding of how to work with the command prompt from the preceding pages of this chapter or you came to this chapter with basic command-prompt skills already. Either way, it's time to put these skills to use with batch files. A batch file is exactly what it sounds like: a file that contains a batch (or collection) of command-prompt commands. You simply type the batch files in a text editor (like the infamous Notepad) and then save them with a .BAT extension. Exercise 4.1 will walk you through creating a batch file, but first, you should understand some basic commands that are useful within batch files.

Using Logic (IF and GOTO)

One of the most important tasks you will need to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required