Post reply

Fullbackup succeeded but no files in disk

  • February 11, 2013 at 8:53 pm

    #270079

    Hi ,

    we are taking full backups every date with script .backup job status is successfull but only one or two databses full backup files exist in the disk. We have enough disk space on the server.

    Thanks,

    lavanya

  • February 12, 2013 at 2:37 am

    #1586887

    Pls provide the script

  • February 12, 2013 at 5:45 am

    #1586959

    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!

  • February 12, 2013 at 6:11 am

    #1586972

    Are you using a custom script or are you using a Maintenance Plan? Could be perhaps some of the backups are going to the default backup folder "<<Installation Path>>"\MSSQL10.MSSQLSERVER\MSSQL\DATA" and others are going to a path you've specified?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply