I'm running SQL 2005 Express. Since there is no sql agent with this I have a batch job that runs a sql script that backs up my database to another server. Is there a way I can include a time date stamp in the backup file name.
Its a real simple script Backup Database <> to disk = path\filename
Right now the filename is DataBaseName.bak I'l like it to look like DataBaseName_DB_DateTime.bak
Is there some way I can put the getDate() in the filename?
Thanks in advance for your helpUniv of Missouri St. Louis ...
Go to the complete details ...