SQL Maintenance Plan - Differential failining
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\
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
Executing the query "BACKUP DATABASE [BBNC] TO DISK = N'\\\\roadrunner\\h..." failed with the following error: "Cannot open backup device '\\\\roadrunner\\honeypot\
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
Last Comment
ASKER
Affirmative and yes same user.
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?
There's more detailed information in MSSQL Log and OS Event Log?
ASKER
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::CreateMedi
***************
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::CreateMedi
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
3+ TB available - a reboot may resolve the issue - thx
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
If affirmative, is the same user that runs the full and differential backup jobs or you have different user for each job?