Post reply

Backup history in msdb databases

  • March 9, 2006 at 1:17 pm

    #365466

    We have a process which runs at night and we take differential backups at different steps. We take 5 differentials.

     

    Last night SQL Server logs show that 5th differential is done and I can see the .bak file. But it did not write anything into backupmediafamily table in msdb databases. I see an entry in backupmediafamily table in msdb for the remaining 4 backups.

     

    I looked at the backupset table and I see the corresponding row has media_set_id (which was created for 5th differential 3 days back).

     

    This happened in sequence for two nights. Any ideas on this??

  • March 13, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • March 16, 2006 at 6:16 am

    #626992

    Have you actually checked that the backups are good - 'cos that's what I'd do first. I'd also check the sql and event logs just in case you're running low on disk space

     

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • March 20, 2006 at 8:51 am

    #627640

    I have restored the backups on a different server and it worked great !

    I have lots of free space on the disk.

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

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