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

• unrealll

  Valued Member

  Points: 63

  More actions

  February 12, 2013 at 12:43 pm

  #274053

  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

• vivekinmadar

  Right there with Babe

  Points: 745

  More actions

  February 17, 2013 at 6:19 am

  #1588661

  Hi unreall,

  Can please check this link

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