Pages
Tags
:ERROR SQLCMD Command :LIST SQLCMD Command :LISTVAR SQLCMD Command :ON ERROR :ON ERROR SQLCMD :PERFTRACE SQLCMD :PERFTRACE SQLCMD Command :XML :XML SQLCMD Command :XML [ON/OFF] SQLCMD Command Automate Backup with SQLCMD CMD command CMD list of the servers OPENROWSET OPENROWSET excel file OSQL RESET SQLCMD command SERVERLIST SERVERLIST SQLCMD Command SQLCMD SQLCMD Backup SQLCMD Batch SQLCMD command SQLCMD list of the servers SQLCMD Script SQLCMD Scripting Variables SQLCMD Startup Script sqlcmd stored proc SQLCMD T-SQL SQLCMD Variables Startup Script stored procedure sqlcmd XP_CMDSHELL XP_CMDSHELL excel file XP_CMDSHELL SQL 2000 XP_CMDSHELL SQL 2005 XP_SMDSHELL [:]ED SQLCMD Command [:]EXIT[(statement)] SQLCMD Command [:]QUIT SQLCMD CommandCategories
Tag Archives: Automate Backup with SQLCMD
Automate Backup Process With SQLCMD
Automate Backup Process — can create SQL Scheduled Task that will call and execute this SQL (everynight for example) declare @Dt_DateAndTime Varchar(100), @backupfile sysname, DECLARE @ThreeDaysAgo VARCHAR(50) select @Dt_DateAndTime = convert(char(8), getdate(), 112)+”+ Replace(convert(char(12), getdate(), 14),’:’,”) select @Dt_DateAndTime select @backupfile … Continue reading