SQLUSA
FREE TRIAL  CLICK HERE TO ORDER  SEARCH
SQL Server 2008 Training Scripts
SQL Server 2005 Training Scripts
SQL Server Training Scripts
SQL 2008 GRAND SLAM
How to execute a cmd file?

The following sample copy file command shell can be saved into a file called weeklybackup.cmd:

 

XCOPY D:\backup\accountmaster.bak \\ServerIP\D$\backup\accountmasterweekly.bak /Q

 

The cmd file can contain other operating system commands as well. It can be executed from xp_cmdshell or SQL Server Agent just by giving the name "weeklybackup.cmd".

The World Leader in SQL Server 2008 Training
Order SQL 2008 GRAND SLAM Today!
The Future is just a CLICK away! Your Future!
SQLUSA.com Home Page

Copyright 2005-2010, SMI Corp. All Rights Reserved.

SQL Server 2008 is a program product of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.