Server A: Windows Server 2003 x64, SQL Server 2005, NetBackup 7.5
Server B: Windows Server 2008 x64, SQL Server 2012, NetBackup 7.5
From Server A, we're trying to restore a backup from SQL Server 2005 to Server B, which has newly installed SQL Server 2012, after running for about one hour it error out with this error: "Cannot open backup device 'xxxxxxx'. Operating system error 0x80070002(The system cannot find the file specified.)"
Any advise how to resolve this issue?
Here is the condensed error log file:
ERR - Error in GetConfiguration: 0x80770003.
CONTINUATION: - The api was waiting and the timeout interval had elapsed.
DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <3201><[Microsoft][SQL Native Client][SQL Server]Cannot open backup device 'XXXXXXX'. Operating system error 0x80070002(The system cannot find the file specified.).>.
DBMS MSG - SQL Message <3013><[Microsoft][SQL Native Client][SQL Server]RESTORE DATABASE is terminating abnormally.>
ERR - Error in VDS->Close: 0x80770004.
My first question as well - did you verify that Microsoft supports this kind of restore?
If so, we need more information.
What exact steps were taken to perform redirected restore?
Please post restore script as well as dbclient log on Server B. (Hope you have created dbclient log folder before attempting the restore.)
It is possibe that your restore failure is caused by Client Read Timeout - see this topic in NBU for SQL Admin Guide:
If you use SQL Server 2005 or later, you can eliminate file initialization during SQL Server restores.See “About instant data file initialization” on page 52.
I can see that the Server A: Windows Server 2003 is a 64 bit system.
What is your 2005 SQL 64 or 32 bit?
If I remember correctly there is a problem restoring 32 bit to 64 bit SQL.
Restore Corrupted SQL server 2005, 2000, 2008 and 2012 database with all objects like: table, views, triggers and primary key etc. for more info: http://www.articlesbase.com/software-articles/sql-database-recovery-assured-with-technical-intellect...
Do one thing... first of all u didnt mention where the bak file location that you want to restore...
i think its on some other drive except C:\.So do one thing give permisssion for the drive that situate the DB backup.
1.Right click and go to properties>security>select the user>edit >give tick ,ark to all check box...
<> Done...Try to restore