how to put running consicutive number as suffix to my sqlserver bakup file.

That’s where i need the help.

i have to suffixe a running consicutive number to the bakup file like

AbcDB_2014-01-27 13:44:46.013_1.bak

AbcDB_2014-01-27 13:44:46.013_2.bak

or one can remove the fraction of sec.

AbcDB_2014-01-27 13:44:46_1.bak

AbcDB_2014-01-27 13:44:46_2.bak

but in all case i need the 1,2,3,4........ with in the day it can repeat from next day.

yours sincerly