Category Archives: SETVAR

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