03-31-2013 08:10 PM
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.
Thank you!
03-31-2013 08:53 PM
Do verify if SQL 2012 is set to accept DB from legacy version. ask DBA to check that
Also increase timeout in restore script to 1800 and check
03-31-2013 09:56 PM
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.
04-01-2013 06:49 AM
04-01-2013 07:03 AM
silly question.
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.
04-01-2013 07:18 AM
Hi Stefanos,
I checked SQL Server 2005, from Server Properties - Product, it indicate "Mircrosoft SQL Server Enterprise Edition (64-bit)"
04-01-2013 07:57 AM
.... indeed we encountered timeout failure.
Have you tried a timeout of 3 hours or else instant data file initialization as per my previous post?
Have you tried to work through any of the suggestions in you other post?
04-04-2013 11:43 AM
Are you using Always On/Availability Groups ?
05-17-2013 04:20 AM
Hello
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...
Regards
Fadric Smith
03-21-2017 09:13 PM
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