Kaiser_Kamal
2 Iron

Unable to restore SQL backup

I am trying to restore sql DB backup i am getting this error,

Error:

Recovering files of client 'MSALESDB-RYD.asd.com' from server 'afg-nw-dr.asd.com' to client 'AFG-NET-MSALES3'.

43708:(pid 4492):Start time: Thu Nov 10 11:51:17 2016

43621:(pid 4492):Computer Name: AFG-NET-MSALES3     User Name: omnibkadm

                  NSR_CLIENT: MSALESDB-RYD.asd.com;

                  NSR_SERVER: afg-nw-dr.asd.com;

37725:(pid 4492):Recovering database 'mSales' into 'mSales' ...

4690:(pid 4492):RESTORE database [mSales] FROM virtual_device='Legato#42cca529-2741-48e4-8873-daad29853ebb'  WITH move 'mSales18Nov_Data' to 'F:\Restore\mSales\mSales_mSales_mSales18Nov_Data_13986_13260.mdf', move 'mSalesLog' to 'F:\Restore\mSales\mSales_mSales_mSales_log_13986_13260.ldf'

37840:(pid 4492):Error opening tape session for MSSQL:/mSales.

70829:(pid 4492):VDI device did not close properly.

0 Kudos
6 Replies
ledugarte
3 Argentum

Re: Unable to restore SQL backup

Take a look into applogs. Maybe some details are given in these logs.

0 Kudos
ble1
7 Thorium

Re: Unable to restore SQL backup

As this is directed recovery, make sure permissions are in place (including disk space).  Next, check logs in applogs on client, but also on backup server for timeframe when session was running to get more details about real nature of the error.

0 Kudos
Kaiser_Kamal
2 Iron

Re: Unable to restore SQL backup

Dear Ble

Permission is full disk space also available .

Error from event viewer .

SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=1688. Thread=3176. Server. Instance=MSSQLSERVER. VD=Global\Legato#76a72cb1-8406-4343-90e5-e70ef1e0269d_SQLVDIMemoryName_0.

Applogs nsrsql attached.

Best Regards

Kaiser Kamal | Data Center Technician

Al Faisaliah Group Holding Company

P.O. Box 16460 Riyadh 11464| Kingdom of Saudi Arabia

•: +966 11 2439822 Ê: +966 11 243 9999 x 9822

•: kkamal@alfaisaliah.com<mailto:kkamal@alfaisaliah.com>

Website: www.alfaisaliah.com<http://www.alfaisaliah.com/>

0 Kudos
ledugarte
3 Argentum

Re: Unable to restore SQL backup

Try a recover of a filesystem from afg-nw-dr.asd.com to AFG-NET-MSALES3. If it is OK, we can isolate the problem to SQL.

0 Kudos
ElanC
3 Silver

Re: Unable to restore SQL backup

This could be due to the hostname mismatch in the SQL Client and NW Server.

Can you add a host entry for "MSALESDB-RYD.asd.com" in both the machines (SQL client and NW Server) and re-try the restore operation.

Thanks,

0 Kudos
Kaiser_Kamal
2 Iron

Re: Unable to restore SQL backup

Hello

Host entry are available on both the servers.

Still failing.

Best Regards

Kaiser Kamal | Data Center Technician

Al Faisaliah Group Holding Company

P.O. Box 16460 Riyadh 11464| Kingdom of Saudi Arabia

•: +966 11 2439822 Ê: +966 11 243 9999 x 9822

•: kkamal@alfaisaliah.com<mailto:kkamal@alfaisaliah.com>

Website: www.alfaisaliah.com<http://www.alfaisaliah.com/>

0 Kudos