copy file to a folder

[encata]

I have scheduled backup file (BK.bkf)in SQL overwritten daily.I want to copy this backup file to a folder. The folder is going to hold the daily backup files with different names,so that i will have 30 files at the end of the month.

can you help me with any scripts to automate the job.

Thanks

Why you worry? Life is too short to worry.

 

[Jamfool]

you could do this using

EXEC master..xp_cmdshell 'xcopy c:\*.* d:\*.*'

http://www.computerhope.com/xcopyhlp.htm