I am using a custom made application that is using MSDE 2000 transact SQL. Thing is that I've made a simple batch file in order to save databases automatically every day but it seems I made a mistake... I never expected the server to save in the same file if the file already exists (thought it will overwrites it) in the destination folder and now I have a single file with multiple backups in it. Is there a way to separate backups within this file and to extract only the last backup? Restoring this backup file recreates the database with no error but it actually restores the first backup (the oldest).
The line used to save database is something like this:
osql -Usa -P -n -Q "BACKUP DATABASE ciel1 TO DISK = 'e:\BackUp2\Ciel1_1.bak'"
Thanks in advance for any help.....:)...