Balance (10/22/2012)
What an idiot - I was getting the date's on files mixed up - looks like backup each night is writing to the wrong file name (so Saturday wrote to Tuesday). How we got there I don't know but panic over 🙂
how this could be happened ? i thnk u would be adding datettime as SUFFIX to backup file for reference (through job or maintenance plan)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)