I am running the following sqllitespeed backup script on Windows 2003 Server
against SQL Server 2000
sqllitespeed -Bdatabase -T -DNorthwind -FH:\MicrosoftSQLServer\BACKUPS\DATABACKUPS\NorthWi nd\northwind.bak
How could I place the date variable into the output filename?
I've tried variations of %date% etc but nada.
Any thoughts?
Thanks in advance.
Gerryhow do you executye this? Command line?, xp_cmdshell?|||It would be in a script run by an external controller.
A batch file.|||OK, batch file
I would use T-SQL to create said batch fiile, and as a matter of fact I would have a sql server job lauch said batch file
No comments:
Post a Comment