Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

SQL Restore to remote host

Updated: 22 May 2010 | 8 comments
Mindaugas Laucius's picture
Mindaugas Laucius
0 0 Votes
Login to vote
Hi,
 
I have issues with SQL remote restore. I follow SQL restore instructions profided my Veritas and I received folowing errors:
 
In restore status window:
INF - Created VDI object for SQL Server instance <server name>. Connection timeout is <300> seconds.
ERR - Error in GetConfiguration: 0x80770003.
---------
 
In Event log on remote host:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date:  7/20/2007
Time:  11:52:59 AM
User:  CORP\lauciusm-adm
Computer: ISDVA1-SQL01
Description:
18210 :
BackupVirtualDeviceSet::Initialize: Open failure on backup device 'VNBU0-7756-8816-1184946779'. Operating system error 0x80070002(The system cannot find the file specified.)

Event Type: Error
Event Source: SQLVDI
Event Category: None
Event ID: 1
Date:  7/20/2007
Time:  11:52:59 AM
User:  N/A
Computer: ISDVA1-SQL01
Description:
SQLVDI: Loc=SVDS::Open. Desc=Open(Control). ErrorCode=(2)The system cannot find the file specified.
. Process=1584. Thread=4996. Server. Instance=MSSQLSERVER. VD=Global\VNBU0-7756-8816-1184946779_SQLVDIMemoryName_0.

Do you have any ideas why restore fails? I tried different SQL servers, same issues. Local restore works w/o any problems..

Win20003, SQl 2000, NBU 6.0Mp4

Thanks!

Discussion Filed Under:
, ,

Comments

Omar Villa's picture
30
Jul
2007
0 Votes 0
Login to vote
Omar Villa

checking on this:
 
INF - Created VDI object for SQL Server instance <server name>. Connection timeout is <300> seconds.
 
 Why u dont try to increase the connection time out to 7200

Omar A Villa

Netbackup Expert

These are my personal views and not those of the company I work for

Chia Tan Beng's picture
31
Jul
2007
0 Votes 0
Login to vote
Chia Tan Beng

Have you set the appropriate altnames?
Mindaugas Laucius's picture
31
Jul
2007
0 Votes 0
Login to vote
Mindaugas Laucius

I don't think so this will help. I noticed that error in event log is recorded right after restore procedure starts and nothing is happening for the rest 595 seconds.. :(
Mindaugas Laucius's picture
31
Jul
2007
0 Votes 0
Login to vote
Mindaugas Laucius

I didn't set any alt names... I didn't any information about this in pdf.. Chia, could you give more details?
 
Thanks!
Stumpr2's picture
31
Jul
2007
0 Votes 0
Login to vote
Stumpr2
Trusted Advisor

How to restore an SQL Server database that includes a differential image to an alternate client using the NetBackup for Microsoft SQL Server Agent
 
 
Mindaugas Laucius's picture
07
Aug
2007
0 Votes 0
Login to vote
Mindaugas Laucius

Hi,
 
Thanks Bob for interesting link.
 
I spoke with Symantec support and found out that I had to run restore script on destination host.. :D I guess I missed this in PDF... :P
Stumpr2's picture
07
Aug
2007
0 Votes 0
Login to vote
Stumpr2
Trusted Advisor

I bet you will never miss that again! Experience may not be the best teacher but it certainly is the hardest :smileyvery-happy:
 
 
Mindaugas Laucius's picture
09
Aug
2007
0 Votes 0
Login to vote
Mindaugas Laucius

Yeah, it definitely is. I've just review VERITAS PDF again and didn't find in instruction that I have to run restore script on destination server.. :D
 
Anyway, I learned my lesson!

Technical Support

Symantec.com

Store

Community Stats

Total Content Items
Members
270,018