troubleshooting Question

SQL Maintenance Plan - Differential failining

Avatar of franco2
franco2Flag for Canada asked on
Microsoft SQL Server 2008Storage SoftwareMicrosoft SQL Server
6 Comments1 Solution419 ViewsLast Modified:
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
Vitor Montalvão
IT Engineer
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros