I am trying to backup database on limited size drive
In options for backup I picked overwrite existing file, but for some reasons it still creates new file with the date associated with it
What strange about that is ,it strippes old file from the date and new file has the date in file name
If you are using the Database Maintenance planner or the xp_sqlmaint procedure, they will use a file naming convention which may be different than the old backup that is on your system, so they won't touch the old file because they don't recognize it.
Also, when overwriting files, Windows applications typically create a new file and then delete the old file and rename the new file when the new file is complete. So you can still run out of disk space if you don't have enough room for two copies of the file.