GUID as path and backup file sent to nowhere but no error... ????

  • This one is quite strange :

    I recently created a maintenance plan that take full backups of our BDs and backup them to an UNC path that points to our NAS server (backed up on tape later). Another maintenance plan runs every day to delete old backup files (we keep all our tapes anyway, each tape is used 1 time and never used again - except when in need to restore some data)

    Today I realised that no backup are present in the folder I specified. No error in backups, no notification, no error message. Have launched the backup operation 3 times and SQL server reported that operations were successful each time. But still, no backup file. Seems like my backups are going in a black hole or something like this...

    I ran a query to det some more info about past maintenance plan executions and I found this :

    Instead of having my UNC path as location for backup, I have {4A52B263-28CD-4519-B3E2-66AF44B9BD6F}13 (it is a GUID??) or something similar for eachbase that was backuped via this maintenance plan.

    When I open the maintenance plan for editing in Management Studio, my path is here. I produce a script for the same operation, my path is here. I check backup history, I have a GUID instead.

    Can someone tell me what is hapening here?

    Thanks

    Nico

  • Hi unreall,

    Can please check this link

    http://www.mssqltips.com/sqlservertip/1583/changing-the-default-sql-server-backup-folder/

Viewing 2 posts - 1 through 1 (of 1 total)

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