Category Archives: SQLCMD

SQL Server: Monitoring Disk Space with FSUTIL command line utility

Posted on September 27, 2016 by Prashanth Jayaram

Table of Contents Introduction Pre-requisites Data flow Enable xp_cmdshell Download SQL Code Output Conclusion References See Also Introduction This article talks about one of SQL method to fetch the disk usage details and use of T-SQL in conjunction with invoking … Continue reading →

Posted in SQL, SQLCMD, Uncategorized | Tagged , , | Leave a comment

SQLCMD – Database Backup and Restore – Automation – Quickest and Simplest method

Posted on August 19, 2013 by Prashanth Jayaram

In today’s world we rely more on third party tools to do a Backup and Restore of databases. Most of us still use SQL Native method to do a Database Backup and Restoration. This post illustrates the quickest way of … Continue reading →

Posted in Backup and Restore, Robocopy, SETVAR, SQL, SQLCMD, Uncategorized | Tagged , , , | 7 Comments

SQLCMD –Quick Copy of Files – Using Robocopy

Posted on July 5, 2013 by Prashanth Jayaram

The requirement is to move the files to different server programatically and hence I’ve decided to use Robocopy in SQLCMD. Robocopy is a command line utility. It has been available as part of the windows resource kit and It’s one of … Continue reading →

Posted in Robocopy, SETVAR, SQLCMD, T-SQL | Tagged , , | 3 Comments