SQL Maintenance Plan - Differential failining

franco2
franco2 used Ask the Experts™
on
Anyone know why this would be?  The full backup in the same maintenance plan works but the differential doesn't.  BTW - setup is identical in the sub plan.  Working perfectly for approx 3 months - as of last Thursday getting the following:

Executing the query "BACKUP DATABASE [BBNC] TO  DISK = N'\\\\roadrunner\\h..." failed with the following error: "Cannot open backup device  '\\\\roadrunner\\honeypot\\SMBBackupShare\\BBNC\\BBNC_backup_2015_12_03_160004_2129988.bak’.
 Operating system error 64(The specified network name is no longer available.).
BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

I think it is the double wacks - but the full works without issue
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
The full backup is going to the same share and folder?
If affirmative, is the same user that runs the full and differential backup jobs or you have different user for each job?

Author

Commented:
Affirmative and yes same user.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
That's weird. This only let you with a network issue that only happens during differential backup (even more weird).
There's more detailed information in MSSQL Log and OS Event Log?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
SQL Log
***************
Date            12/3/2015 12:00:07 PM
Log            SQL Server (Current - 11/5/2015 7:19:00 AM)
Source            spid69
Message
Error: 18204, Severity: 16, State: 1.
***************
Date            12/3/2015 12:00:07 PM
Log            SQL Server (Current - 11/5/2015 7:19:00 AM)
Source            spid69
Message
BackupDiskFile::CreateMedia: Backup device '\\roadrunner\honeypot\SMBBackupShare\BBNC\BBNC_backup_2015_12_03_120003_6769942.bak' failed to create. Operating system error 59(An unexpected network error occurred.).
IT Engineer
Distinguished Expert 2017
Commented:
In the main question the error was:
  Operating system error 64(The specified network name is no longer available.).

Now changed to:
  Operating system error 59(An unexpected network error occurred.).

If really seems to be related to a network problem.
By the way, did you check the available free space in the backup share? You may also run out of space there.

Author

Commented:
3+ TB available - a reboot may resolve the issue - thx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial