06-25-2019 03:18 AM
Hi All,
We are performing SQL Database restore using script. Size of the DB is approx 1.5 TB and we are using Tapes. Restore is failing after 8-9 hrs. Request anyone to please help us.
06-25-2019 04:20 AM
You have not given us anything to work with....
Can you show us all text in Details tab of failing job?
Did you create dbclient log on the destination client and increased logging level to 3?
Have you checked NBU for SQL manual regarding large DB restore?
Look for: "About minimizing timeout failures on large SQL Server database restores"
06-25-2019 04:22 AM - edited 06-25-2019 04:23 AM
Have you set the Instant data file initialization ? If not, that's probably a good start. It is described in the NBU SQL admin guide as far as I remember.
Is there any firewalls between the netbackup servers and the SQL server ? Most firewalls closes the connection if it has been idle for while.
Other than that, use the bphdb and dbclient logs, think they are describe in troubleshooting section of NBU SQL admin guide.
06-25-2019 06:15 PM
Do you have free space on disk to your restore?
06-26-2019 05:25 AM
Don't get me started on SQL. I gave up on it and now we backup to disk and I backup the disk files for recovery purposes.
We were only able to have success restoring if we single thread the recovery - which takes too long.
Sorry NetBackup, IMHO your SQL recovery does not meet our needs.