Forum Discussion

H_Sharma's avatar
H_Sharma
Level 6
10 years ago
Solved

Media Server Failover

Hello Experts, I have a windows client and need to restore some SQL database. It gets failed with Network issue (41) Error code every time and taking only 1 media server i.e for sv5.net . 19/03/2016 09:17:32 - Info bptm(pid=15924) INF - Waiting for positioning of media id 0T67L4 on server sv5.net for reading. May I change Media server sv5.net to another for this client restore only? Thanks & Regards,
7.6
Backup and Recovery
NetBackup
Restore
Windows Server (2003-2008)
  • Marianne's avatar
    Marianne
    10 years ago
    SQL restore needs a LONG LONG Client Read Timeout on the media server so that SQL can initialize the database. Something like 3 hours (7200) is normally sufficient. You can read up about this in NBU for SQL Guide. Media server failover on Windows master is in Host Properties - > Master - > Universal settings - > Media Host override

4 Replies

Sort By
  • Marianne's avatar
    Marianne
    Level 6
    10 years ago
    SQL restore needs a LONG LONG Client Read Timeout on the media server so that SQL can initialize the database. Something like 3 hours (7200) is normally sufficient. You can read up about this in NBU for SQL Guide. Media server failover on Windows master is in Host Properties - > Master - > Universal settings - > Media Host override
  • H_Sharma's avatar
    H_Sharma
    Level 6
    10 years ago
    Thanks Marianne. Do we need to restart any Master/Media Netbackup services after making the below changes? Media server failover on Windows master is in Host Properties - > Master - > Universal settings - > Media Host override
  • Marianne's avatar
    Marianne
    Level 6
    10 years ago
    I cannot remember if a restart is needed. Try it without restart and see what happens. If original media server is again chosen, use cluster commands/utilities to restart NBU. Before you do that - the media server is hardly ever the reason for Client Read Timeout during SQL restore. The reason is the time needed for SQL to initialize the database. Please search for 'timeout' in NBU for SQL Guide. Rather increase the timeout on the media server or read up in above manual about initializing of SQL db.