February 2015 – PCHELP Your Local IT Business and Residential Support Provider

Sql Server Express Automate Backup

By Site Blog

February 28, 2015

Create a backup SQL script for database name and location then create a scheduled task from the following batch file command “C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE” -S RTMTERMSERVER\WZ -i c:\WZBU\WZBackup.sql SERVERNAME Location of SQL Script

Long file name unable to delete in a deep hierarchy on a drive

By Site Blog

February 17, 2015

| No Comments

| General Posts

Share the top level folder on the server. Then map a drive to a folder further down in the hierarchy. \\server\share\folder1. Then delete files or subfolders.