Category Archives: SQLCMD

SQL Server: Monitoring Disk Space with FSUTIL command line utility

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

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

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