Filename for database dump no longer with timestamp?

Hi there!

When performing a database dump to a file with SQL Server 6.5, the timestamp was automatically used as the extension for the file. After migrating to SQL Server 2000, this no longer seems to be the case :-(

Is there a way to have the timestamp included in the filename (apart from writing a Windows script to change the filename after the file has been created, of course)?

Rgds,
MauritsOriginally posted by hafkenscheid
Hi there!

When performing a database dump to a file with SQL Server 6.5, the timestamp was automatically used as the extension for the file. After migrating to SQL Server 2000, this no longer seems to be the case :-(

Is there a way to have the timestamp included in the filename (apart from writing a Windows script to change the filename after the file has been created, of course)?

Rgds,
Maurits
In SQL7 if you go in the EM unser the Server Group -> Management -> DB Maint Plans and build a mint plan. I think the auto-delete after days puts the date time stamp on the file name.

Probably hasn't changed in SQL2K|||That's it! Thank you very, very much!

Regards,
Maurits