This post is more than 5 years old
8 Posts
0
2477
December 18th, 2007 04:00
MSSQL: Full backup of * not found, cannot recover
Basically, we cannot restore any MSSQL DB. Not even verify. The backup says it is successful. Here are the logs:
[5692] 12/16/07 23:30:06 Start time Sun Dec 16 23:30:06 2007
[5692] 12/16/07 23:30:06 Computer Name: MSSQL User Name: NT AUTHORITY\SYSTEM (SYSTEM)
[5692] 12/16/07 23:30:06 System Version: 5.0 Build 2195 Service Pack 4
[5692] 12/16/07 23:30:06 Microsoft Data Access Component(MDAC) version: 2.81.1117.6
[5692] 12/16/07 23:30:06 Microsoft SQL Server version (from registry) : 8.00.194
[5692] 12/16/07 23:30:06 Local host has following SQL Server online:
[5692] 12/16/07 23:30:06 MSSQL server : MSSQL
[5692] 12/16/07 23:30:06 Use Legato Networker Server : corbs027.olysteel.com
[5692] 12/16/07 23:30:06 Legato Networker Server Version: NetWorker nw_7_3_2_jumbo.Build.386 Network Edition/35
[5692] 12/16/07 23:30:06 nsrexecd.exe Version: nw_7_3_2_jumbo.Build.386
[5692] 12/16/07 23:30:06 nsrsqlsv.exe Version: 5.0.0.154 Supporting SQL 7.0, SQL 2000, and SQL 2005
[5692] 12/16/07 23:30:06 Command line:
[5692] 12/16/07 23:30:06 C:\Program Files\Legato\nsr\bin\nsrsqlsv.exe -s corbs027.olysteel.com -g OSI Daily DB -LL -m mssql -l full -q -W 78 -N MSSQL: MSSQL:
[5692] 12/16/07 23:30:07 SQL Connection to MSSQL is created. SQL Server Version is 08.00.2039
NSR_BACKUP_LEVEL: full;
NSR_GROUP: OSI Daily DB;
NSR_SAVESET_NAME: "MSSQL:";
NSR_SERVER: corbs027.olysteel.com;
[5692] 12/16/07 23:30:13 Backing up of BV succeeded.
[5692] 12/16/07 23:30:13 The backup of BV has completed successfully
[5692] 12/16/07 23:30:19 Backing up of CallAccounting succeeded.
[5692] 12/16/07 23:30:19 The backup of CallAccounting has completed successfully
[5692] 12/16/07 23:30:25 Backing up of INSIGHT_DB_V32 succeeded.
[5692] 12/16/07 23:30:25 The backup of INSIGHT_DB_V32 has completed successfully
[5692] 12/16/07 23:30:30 Backing up of Insight_v50_0_141417156 succeeded.
[5692] 12/16/07 23:30:30 The backup of Insight_v50_0_141417156 has completed successfully
[5692] 12/16/07 23:31:52 Backing up of Millennium succeeded.
[5692] 12/16/07 23:31:52 The backup of Millennium has completed successfully
[5692] 12/16/07 23:31:55 Backing up of Northwind succeeded.
[5692] 12/16/07 23:31:55 The backup of Northwind has completed successfully
[5692] 12/16/07 23:31:58 Backing up of PMP_V3_0 succeeded.
[5692] 12/16/07 23:31:58 The backup of PMP_V3_0 has completed successfully
[5692] 12/16/07 23:32:01 Backing up of PPA_DB_V2 succeeded.
[5692] 12/16/07 23:32:01 The backup of PPA_DB_V2 has completed successfully
[5692] 12/16/07 23:32:12 Backing up of Reporting succeeded.
[5692] 12/16/07 23:32:12 The backup of Reporting has completed successfully
[5692] 12/16/07 23:32:26 Backing up of VMware succeeded.
[5692] 12/16/07 23:32:26 The backup of VMware has completed successfully
[5692] 12/16/07 23:32:28 Backing up of VMware75tst succeeded.
[5692] 12/16/07 23:32:28 The backup of VMware75tst has completed successfully
[5692] 12/16/07 23:32:32 Backing up of master succeeded.
[5692] 12/16/07 23:32:32 The backup of master has completed successfully
[5692] 12/16/07 23:32:36 Backing up of mgmtdb succeeded.
[5692] 12/16/07 23:32:36 The backup of mgmtdb has completed successfully
[5692] 12/16/07 23:32:39 Backing up of model succeeded.
[5692] 12/16/07 23:32:39 The backup of model has completed successfully
[5692] 12/16/07 23:32:42 Backing up of msdb succeeded.
[5692] 12/16/07 23:32:42 The backup of msdb has completed successfully
[5692] 12/16/07 23:32:45 Backing up of pubs succeeded.
[5692] 12/16/07 23:32:45 The backup of pubs has completed successfully
[5692] 12/16/07 23:32:48 Backing up of vmm_db_v2 succeeded.
[5692] 12/16/07 23:32:48 The backup of vmm_db_v2 has completed successfully
[5692] 12/16/07 23:32:49 Skip building named instance directory because there are no named instances installed or running on this machine.
[5692] 12/16/07 23:32:51 Completion time Sun Dec 16 23:32:51 2007
[6232] 12/18/07 07:21:47 Start time Tue Dec 18 07:21:47 2007
[6232] 12/18/07 07:21:47 Computer Name: MSSQL User Name: MSSQL\Administrator (Administrator)
[6232] 12/18/07 07:21:47 System Version: 5.0 Build 2195 Service Pack 4
[6232] 12/18/07 07:21:47 Microsoft Data Access Component(MDAC) version: 2.81.1117.6
[6232] 12/18/07 07:21:47 Microsoft SQL Server version (from registry) : 8.00.194
[6232] 12/18/07 07:21:47 Local host has following SQL Server online:
[6232] 12/18/07 07:21:47 MSSQL server : MSSQL
[6232] 12/18/07 07:21:48 Use Legato Networker Server : corbs027.olysteel.com
[6232] 12/18/07 07:21:48 Legato Networker Server Version: NetWorker nw_7_3_2_jumbo.Build.386 Network Edition/35
[6232] 12/18/07 07:21:48 nsrexecd.exe Version: nw_7_3_2_jumbo.Build.386
[6232] 12/18/07 07:21:48 nsrsqlrc.exe Version: 5.0.0.154 Supporting SQL 7.0, SQL 2000, and SQL 2005
[6232] 12/18/07 07:21:48 Command line:
[6232] 12/18/07 07:21:48 nsrsqlrc -s corbs027.olysteel.com -c mssql -V -I -
[6232] 12/18/07 07:21:48 SQL Connection to MSSQL is created. SQL Server Version is 08.00.2039
[6232] 12/18/07 07:21:50 Command line -I item: -t "Sun Dec 16 23:30:30 2007" "MSSQL:Millennium"
NSR_CLIENT: mssql;
NSR_SERVER: corbs027.olysteel.com;
[6232] 12/18/07 07:21:50 Recovering database 'Millennium' ...
[6232] 12/18/07 07:21:50 Failed to find matching recover object.
[6232] 12/18/07 07:21:50 Full backup of Millennium not found, cannot recover
[6232] 12/18/07 07:21:50 Error processing SQL database 'Millennium'.
[6232] 12/18/07 07:21:50 Completion time Tue Dec 18 07:21:50 2007
[5692] 12/16/07 23:30:06 Start time Sun Dec 16 23:30:06 2007
[5692] 12/16/07 23:30:06 Computer Name: MSSQL User Name: NT AUTHORITY\SYSTEM (SYSTEM)
[5692] 12/16/07 23:30:06 System Version: 5.0 Build 2195 Service Pack 4
[5692] 12/16/07 23:30:06 Microsoft Data Access Component(MDAC) version: 2.81.1117.6
[5692] 12/16/07 23:30:06 Microsoft SQL Server version (from registry) : 8.00.194
[5692] 12/16/07 23:30:06 Local host has following SQL Server online:
[5692] 12/16/07 23:30:06 MSSQL server : MSSQL
[5692] 12/16/07 23:30:06 Use Legato Networker Server : corbs027.olysteel.com
[5692] 12/16/07 23:30:06 Legato Networker Server Version: NetWorker nw_7_3_2_jumbo.Build.386 Network Edition/35
[5692] 12/16/07 23:30:06 nsrexecd.exe Version: nw_7_3_2_jumbo.Build.386
[5692] 12/16/07 23:30:06 nsrsqlsv.exe Version: 5.0.0.154 Supporting SQL 7.0, SQL 2000, and SQL 2005
[5692] 12/16/07 23:30:06 Command line:
[5692] 12/16/07 23:30:06 C:\Program Files\Legato\nsr\bin\nsrsqlsv.exe -s corbs027.olysteel.com -g OSI Daily DB -LL -m mssql -l full -q -W 78 -N MSSQL: MSSQL:
[5692] 12/16/07 23:30:07 SQL Connection to MSSQL is created. SQL Server Version is 08.00.2039
NSR_BACKUP_LEVEL: full;
NSR_GROUP: OSI Daily DB;
NSR_SAVESET_NAME: "MSSQL:";
NSR_SERVER: corbs027.olysteel.com;
[5692] 12/16/07 23:30:13 Backing up of BV succeeded.
[5692] 12/16/07 23:30:13 The backup of BV has completed successfully
[5692] 12/16/07 23:30:19 Backing up of CallAccounting succeeded.
[5692] 12/16/07 23:30:19 The backup of CallAccounting has completed successfully
[5692] 12/16/07 23:30:25 Backing up of INSIGHT_DB_V32 succeeded.
[5692] 12/16/07 23:30:25 The backup of INSIGHT_DB_V32 has completed successfully
[5692] 12/16/07 23:30:30 Backing up of Insight_v50_0_141417156 succeeded.
[5692] 12/16/07 23:30:30 The backup of Insight_v50_0_141417156 has completed successfully
[5692] 12/16/07 23:31:52 Backing up of Millennium succeeded.
[5692] 12/16/07 23:31:52 The backup of Millennium has completed successfully
[5692] 12/16/07 23:31:55 Backing up of Northwind succeeded.
[5692] 12/16/07 23:31:55 The backup of Northwind has completed successfully
[5692] 12/16/07 23:31:58 Backing up of PMP_V3_0 succeeded.
[5692] 12/16/07 23:31:58 The backup of PMP_V3_0 has completed successfully
[5692] 12/16/07 23:32:01 Backing up of PPA_DB_V2 succeeded.
[5692] 12/16/07 23:32:01 The backup of PPA_DB_V2 has completed successfully
[5692] 12/16/07 23:32:12 Backing up of Reporting succeeded.
[5692] 12/16/07 23:32:12 The backup of Reporting has completed successfully
[5692] 12/16/07 23:32:26 Backing up of VMware succeeded.
[5692] 12/16/07 23:32:26 The backup of VMware has completed successfully
[5692] 12/16/07 23:32:28 Backing up of VMware75tst succeeded.
[5692] 12/16/07 23:32:28 The backup of VMware75tst has completed successfully
[5692] 12/16/07 23:32:32 Backing up of master succeeded.
[5692] 12/16/07 23:32:32 The backup of master has completed successfully
[5692] 12/16/07 23:32:36 Backing up of mgmtdb succeeded.
[5692] 12/16/07 23:32:36 The backup of mgmtdb has completed successfully
[5692] 12/16/07 23:32:39 Backing up of model succeeded.
[5692] 12/16/07 23:32:39 The backup of model has completed successfully
[5692] 12/16/07 23:32:42 Backing up of msdb succeeded.
[5692] 12/16/07 23:32:42 The backup of msdb has completed successfully
[5692] 12/16/07 23:32:45 Backing up of pubs succeeded.
[5692] 12/16/07 23:32:45 The backup of pubs has completed successfully
[5692] 12/16/07 23:32:48 Backing up of vmm_db_v2 succeeded.
[5692] 12/16/07 23:32:48 The backup of vmm_db_v2 has completed successfully
[5692] 12/16/07 23:32:49 Skip building named instance directory because there are no named instances installed or running on this machine.
[5692] 12/16/07 23:32:51 Completion time Sun Dec 16 23:32:51 2007
[6232] 12/18/07 07:21:47 Start time Tue Dec 18 07:21:47 2007
[6232] 12/18/07 07:21:47 Computer Name: MSSQL User Name: MSSQL\Administrator (Administrator)
[6232] 12/18/07 07:21:47 System Version: 5.0 Build 2195 Service Pack 4
[6232] 12/18/07 07:21:47 Microsoft Data Access Component(MDAC) version: 2.81.1117.6
[6232] 12/18/07 07:21:47 Microsoft SQL Server version (from registry) : 8.00.194
[6232] 12/18/07 07:21:47 Local host has following SQL Server online:
[6232] 12/18/07 07:21:47 MSSQL server : MSSQL
[6232] 12/18/07 07:21:48 Use Legato Networker Server : corbs027.olysteel.com
[6232] 12/18/07 07:21:48 Legato Networker Server Version: NetWorker nw_7_3_2_jumbo.Build.386 Network Edition/35
[6232] 12/18/07 07:21:48 nsrexecd.exe Version: nw_7_3_2_jumbo.Build.386
[6232] 12/18/07 07:21:48 nsrsqlrc.exe Version: 5.0.0.154 Supporting SQL 7.0, SQL 2000, and SQL 2005
[6232] 12/18/07 07:21:48 Command line:
[6232] 12/18/07 07:21:48 nsrsqlrc -s corbs027.olysteel.com -c mssql -V -I -
[6232] 12/18/07 07:21:48 SQL Connection to MSSQL is created. SQL Server Version is 08.00.2039
[6232] 12/18/07 07:21:50 Command line -I item: -t "Sun Dec 16 23:30:30 2007" "MSSQL:Millennium"
NSR_CLIENT: mssql;
NSR_SERVER: corbs027.olysteel.com;
[6232] 12/18/07 07:21:50 Recovering database 'Millennium' ...
[6232] 12/18/07 07:21:50 Failed to find matching recover object.
[6232] 12/18/07 07:21:50 Full backup of Millennium not found, cannot recover
[6232] 12/18/07 07:21:50 Error processing SQL database 'Millennium'.
[6232] 12/18/07 07:21:50 Completion time Tue Dec 18 07:21:50 2007
No Events found!
smora1
253 Posts
0
December 19th, 2007 07:00
Good luck.
HabibG2
455 Posts
0
December 18th, 2007 05:00
Try initiate a backup and restore from you client.
Do you have multiple instances?
What you saveset looks like?
smora1
253 Posts
0
December 18th, 2007 06:00
Chrisstefan
8 Posts
0
December 18th, 2007 06:00
Only one instance of MSSQL
Saveset?
I will have access to run a client backup and restore in a few hours. I will update then.
Chrisstefan
8 Posts
0
December 18th, 2007 08:00
LGTsc09689
Chrisstefan
8 Posts
0
December 18th, 2007 08:00
smora1
253 Posts
0
December 18th, 2007 08:00
I have seen this KB solution:
Recover of successful MSSQL backup fails
Fact: NetWorker Module for Microsoft SQL 4.0.0.113
Fact: Microsoft SQL 2000
Fact: Windows 2000 SP4
Fact: NetWorker for Windows 7.1.1
Symptom: Recover of successful MSSQL backup fails
Symptom: Error: 'Failed to find matching recover object.'
Symptom: Error: 'Full backup of (DB_name) not found, cannot recover'
Symptom: Error: '_nwbsa_is_retryable_error: received a network error (Severity 5 Number 13): Unknown host'
Cause: Environmental name resolution issue
Fix: Please check and fix all name resolution issues.
For analysis and troubleshooting name resolution issues please have a look at Technical Bulletin 299
Chrisstefan
8 Posts
0
December 18th, 2007 12:00
smora1
253 Posts
0
December 19th, 2007 01:00
Chrisstefan
8 Posts
0
December 19th, 2007 04:00
And this is not a cluster. One networker server, one mssql box.
smora1
253 Posts
0
December 19th, 2007 05:00
nsrsqlrc -s corbs027.olysteel.com -c mssql -V MSSQL:Millennium
this command only verifies if the backup can be recovered.
Chrisstefan
8 Posts
0
December 19th, 2007 06:00
[6164] 12/19/07 09:26:41 Failed to find matching recover object.
[6164] 12/19/07 09:26:41 Recover of 'Millennium' will be skipped because a
full backup was not found.
[6164] 12/19/07 09:26:41 At least 1 valid recover target is required
Thank you so much for your help BTW everyone.
Chrisstefan
8 Posts
0
December 19th, 2007 10:00
XBSA-1.0.1 LNMs_2H_2005.Build.194 6612 Wed Dec 19 11:39:24 2007 _nwbsa_is_retryable_error: received a network error (Severity 5 Number 13): Permission denied, user 'MSSQL' on 'mssql' requires 'Recover local data' privilege for recovery or 'Backup local data' privilege for backup.
EDIT: In fact, no matter what authentication I manually put on the command line I still get this same error.
The person who set up the user permission did not put in the correct user in the administrator users area. Corrected. Thanks everyone. Awarded the answer based on while I was on hold with supposrt I figured it out.
Message was edited by:
Chrisstefan
Message was edited by:
Chrisstefan