sg05121983
asked on
Backup issue - MS SQL server 2005
Hi All,
We are taking Full & Diff backups through SQL Agent (Jobs are scheduled).
All servers backups are running fine. But the Full & Diff backup jobs are failing for 2 servers (SERVER_INST01, SERVER_INST02).
We are not able to find root cause of the issue. Please guide/share suggestions on our backup issue.
Please find the attached diff backup TSQL script & error details given below.
Executing the query "BACKUP DATABASE [ReportServerInt] TO DISK = N'\\\\XYZ.DOMAIN.COM\\MYCO MP\\PROD\\ SERVER_INS T01\\Diffr ential\\Re portServer Int\\Repor tServerInt _backup_20 1301071900 .bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'ReportServerInt_backup_2 0130107190 048', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Write on "\\\\XYZ.DOMAIN.COM\\MYCOM P\\PROD\\S ERVER_INST 01\\Diffre ntial\\Rep ortServerI nt\\Report ServerInt_ backup_201 301071900. bak" failed: 64(The specified network name is no longer available.)
A nonrecoverable I/O error occurred on file "\\\\XYZ.DOMAIN.COM\\MYCOM P\\PROD\\S ERVER_INST 01\\Diffre ntial\\Rep ortServerI nt\\Report ServerInt_ backup_201 301071900. bak:" 64(The specified network name is no longer available.).
BACKUP DATABASE is terminating abnormally.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Executing the query "BACKUP DATABASE [USER_DB1] TO DISK = N'\\\\XYZ.DOMAIN.COM\\MYCO MP\\PROD\\ SERVER_INS T02\\Diffr ential\\US ER_DB1\\US ER_DB1_bac kup_201301 071900.bak ' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'USER_DB1_backup_20130107 190048', SKIP, REWIND, NOUNLOAD, STATS = 10
" failed with the following error: "Write on "\\\\XYZ.DOMAIN.COM\\MYCOM P\\PROD\\S ERVER_INST 02\\Diffre ntial\\USE R_DB1\\USE R_DB1_back up_2013010 71900.bak" failed: 121(The semaphore timeout period has expired.)
A nonrecoverable I/O error occurred on file "\\\\XYZ.DOMAIN.COM\\MYCOM P\\PROD\\S ERVER_INST 02\\Diffre ntial\\USE R_DB1\\USE R_DB1_back up_2013010 71900.bak: " 64(The specified network name is no longer available.).
BACKUP DATABASE is terminating abnormally.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
0
Message
Executed as user: DOMAIN\USER1. ...9.00.5000.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 7:00:00 PM Progress: 2013-01-07 19:00:47.69 Source: {57B2FA24-FD3C-498C-A0BE-D 2EDB289FB7 2}
Executing query "DECLARE @Guid UNIQUEIDENTIFIER
EXECUTE msdb..sp".: 100% complete End Progress Progress: 2013-01-07 19:00:48.69
Source: Back Up Database Task
Executing query "EXECUTE master.dbo.xp_create_subdi r N'\\XYZ.DOMAIN".: 7% complete End Progress Progress: 2013-01-07 19:00:48.74
Source: Back Up Database Task
Executing query "EXECUTE master.dbo.xp_create_subdi r N'\\XYZ.DOMAIN".: 14% complete End Progress Progress: 2013-01-07 19:00:48.79
Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdi r N'\\XYZ.DOMAIN".: 21% complete
End Progress Progress: 2013-01-07 19:00:48.85 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create...
The package execution fa... The step failed.
Thanks in Advance.
Diff-backup-script.txt
We are taking Full & Diff backups through SQL Agent (Jobs are scheduled).
All servers backups are running fine. But the Full & Diff backup jobs are failing for 2 servers (SERVER_INST01, SERVER_INST02).
We are not able to find root cause of the issue. Please guide/share suggestions on our backup issue.
Please find the attached diff backup TSQL script & error details given below.
Executing the query "BACKUP DATABASE [ReportServerInt] TO DISK = N'\\\\XYZ.DOMAIN.COM\\MYCO
" failed with the following error: "Write on "\\\\XYZ.DOMAIN.COM\\MYCOM
A nonrecoverable I/O error occurred on file "\\\\XYZ.DOMAIN.COM\\MYCOM
BACKUP DATABASE is terminating abnormally.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Executing the query "BACKUP DATABASE [USER_DB1] TO DISK = N'\\\\XYZ.DOMAIN.COM\\MYCO
" failed with the following error: "Write on "\\\\XYZ.DOMAIN.COM\\MYCOM
A nonrecoverable I/O error occurred on file "\\\\XYZ.DOMAIN.COM\\MYCOM
BACKUP DATABASE is terminating abnormally.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
0
Message
Executed as user: DOMAIN\USER1. ...9.00.5000.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 7:00:00 PM Progress: 2013-01-07 19:00:47.69 Source: {57B2FA24-FD3C-498C-A0BE-D
Executing query "DECLARE @Guid UNIQUEIDENTIFIER
EXECUTE msdb..sp".: 100% complete End Progress Progress: 2013-01-07 19:00:48.69
Source: Back Up Database Task
Executing query "EXECUTE master.dbo.xp_create_subdi
Source: Back Up Database Task
Executing query "EXECUTE master.dbo.xp_create_subdi
Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create_subdi
End Progress Progress: 2013-01-07 19:00:48.85 Source: Back Up Database Task Executing query "EXECUTE master.dbo.xp_create...
The package execution fa... The step failed.
Thanks in Advance.
Diff-backup-script.txt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER