RE: Fullbackup succeeded but no files in disk

SSC Guru

Points: 323504

February 12, 2013 at 5:45 am

could the script be overwriting the same backup file with differnet databases?

ie the db "Dictionary" gets backed up to C:\Data\Backup.bak, and then the database "SandBox" overwrites teh exact same file C:\Data\Backup.bak with it's backup, instead of being named to match the db?

without the script we can only make guesses, but it's most likely a problem int he script...bad path, overwriting the smae file, appending too the same file, or something.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!