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
Wednesday, March 7, 2012
Question on getting the date value into a filename
Labels:
2000sqllitespeed,
backup,
bdatabase,
database,
date,
dnorthwind,
filename,
following,
microsoft,
mysql,
oracle,
running,
script,
server,
serveragainst,
sql,
sqllitespeed,
value,
windows
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment