SQL Server Restores

Hello Everybody

I am facing some issues to restore my Sql Server Database.

The restore takes a long time, with a small KB/sec transfer, but at the end the error occurs :

 EXIT STATUS 5: the restore failed to recover the requested files

The dbclient logs show a lot of:

10:31:20.284 [4476.556] <2> readFromServer: begin recv -- try=1
10:31:20.296 [4476.556] <2> readFromServer: begin recv -- try=1
10:31:20.309 [4476.556] <2> readFromServer: begin recv -- try=1
10:31:20.320 [4476.556] <2> readFromServer: begin recv -- try=1
10:31:20.332 [4476.556] <2> readFromServer: begin recv -- try=1

Any suggest?

Thanks

Tags (2)
2 Replies
Highlighted

Re: SQL Server Restores

 Hi andrich2016,

    Please share below details,

1. How big is the DB? As bigger DB need more time for initialization and take longer time to complete. Increase Client read timeout value on Client and Media Host Properties.

2. Please share me the restore script to check its parameters.

3. Try disabling AV or Exclude Veritas folder , if any on SQL server. 

4. Also if its related to Network issue, check the backup speed and if you have multiple NIC's on client and by which NIC its communicating while restore.

Hope this helps.

Re: SQL Server Restores

The SQL Database size is 215GB. There is no antivirus active on server.

#
# This is a template for the database MOVE command.
#
OPERATION RESTORE
OBJECTTYPE DATABASE
RESTORETYPE MOVE
#
# Replace the database name in the following line with the name of the database that you
# want to move to. Also remove the hash mark <#> which precedes the keyword <DATABASE>.
#
DATABASE "OpenRIS_TESTE"
#
# Replace the file path <F:\OpenRis\OpenRIS.mdf>
# with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
# The target of the MOVE keyword must be "OPENRIS_Data".
MOVE "OPENRIS_Data"
TO "F:\Teste2\OpenRIS.mdf"
#
#
# Replace the file path <F:\OpenRis\OpenRIS_log.ldf>
# with a new file path. Also remove the hash mark <#> which precedes the keyword <TO>.
# The target of the MOVE keyword must be "OPENRIS_Log".
MOVE "OPENRIS_Log"
TO "F:\Teste2\OpenRIS_log.ldf"
#
# The following image is type: Full
NBIMAGE "SVDBGF.MSSQL7.SVDBGF.db.OpenRIS.~.7.001of001.20181225222512..C"
SQLHOST "SVDBGF"
SQLINSTANCE "OPENRIS_TESTE"
NBSERVER "SVBACKUP7"
BROWSECLIENT "SVDBGF"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE