We would like to backup our ServiceDesk in case the unfortunate happens.
I have setup a scheduled task which uses the following:
osql -S server.mydomain.com -U sqlbackup -Q "BACKUP DATABASE ServiceDesk TO DISK = 'N:\ServiceDesk Backup\ServiceDesk.bak'"
Is there a way I can use the current date to rename the file? e.g ServiceDesk_101110.bak