DosTips.com

I'm using this string to backup via comand line (SQLCMD) a db on sql.

BACKUP DATABASE [NameDB] TO DISK = N'c:\SqlDB\NameDB.bak' WITH NOFORMAT, NOINIT, NAME = N'NameDB-Full DB Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10


I wish, through windows "Scheduled task", run daily backups.
Obviously the file would be overwritten.

Is it possible to scan the string with a batch file, searching the filename and appending it with a time stamp?

example NameDB.bak becomes NameDBYYYYmmddhhmm.bak (NameDB201103151400.bak )

NibbioTNT
thx

Well, in batch this can get you a timestamp. Not sure if this helps:

ChickenSoup wrote:Well, in batch this can get you a timestamp. Not sure if this helps:

Code: Select all

echo %date:~-4%%date:~-7,2%%date:~-10,2%%time:~0,2%%time:~3,2%

as usual, the output of this method is dependent on regional settings on the individual computer its run on. You will have to do some tweaks to it, (that's why i say batch s**ks) , or use vbscript (powershell)

thx, i'll try it

Good idea, !k. I had some problems to save the value in a variable. I guess it has to do with the fact that the output is encoded in unicode little endian. For some reason when I tried...

... I found only a CR character in %timestamp%.

This worked:

Regards
aGerman