Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

GUID as path and backup file sent to nowhere but no error... ???? Expand / Collapse
Author
Message
Posted Tuesday, February 12, 2013 12:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 31, 2013 2:10 PM
Points: 1, Visits: 12
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
Post #1419155
Posted Sunday, February 17, 2013 6:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 17, 2014 12:36 PM
Points: 41, Visits: 165
Hi unreall,


Can please check this link
http://www.mssqltips.com/sqlservertip/1583/changing-the-default-sql-server-backup-folder/
Post #1420973
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse