MSSQL Resore not started

[shahriar_sadm]

Hi dear all,

I have a MSSQL backup and I want to restore it on diffrent host, I completed all steps in admin guide for remote restore. when I tun script via "Manage script" no restore jobs are initiated on master. 

This is the dbclient log for target client that ran the script.

Thanks

16:21:36.923 [9680.7408] <2> vnet_pbxConnect: pbxConnectEx Succeeded
16:21:36.923 [9680.7408] <2> logconnections: BPRD CONNECT FROM target.ip.58089 TO master.ip.1556 fd = 600
16:21:36.939 [9680.7408] <2> vnet_pbxConnect: pbxConnectEx Succeeded
16:21:36.939 [9680.7408] <2> logconnections: BPRD CONNECT FROM target.ip.58090 TO master.ip.1556 fd = 600
16:21:36.955 [9680.7408] <4> CGlobalInformation::VCSVirtualNameList: INF - Veritas Cluster Server is not installed.
16:21:36.955 [9680.7408] <1> CGlobalInformation::VCSVirtualNameList: CONTINUATION: - The system cannot find the path specified.
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: SQL Native Client
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\Microsoft SQL Native Client\
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\SQL Native Client\
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - Registry entry not found for: SOFTWARE\Microsoft\Microsoft SQL Native Client\
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: SQL Server Native Client 10.0
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\Microsoft SQL Server Native Client 10.0\
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\SQL Server Native Client 10.0\
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - Registry entry not found for: SOFTWARE\Microsoft\Microsoft SQL Server Native Client 10.0\
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: SQL Server Native Client 11.0
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\Microsoft SQL Server Native Client 11.0\
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\SQL Server Native Client 11.0\
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - ODBC Driver: SQL Server Native Client 11.0 is installed on the system
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: ODBC Driver 11 for SQL Server
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\MSODBCSQL11\
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\ODBC Driver 11 for SQL Server\
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - ODBC Driver: ODBC Driver 11 for SQL Server is installed on the system
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - Searching for ODBC Driver: SQL Server
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - Registry Install Path: SOFTWARE\Microsoft\DataAccess\
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - ODBC Driver Entry Registry Path: SOFTWARE\ODBC\ODBCINST.INI\SQL Server\
16:21:36.955 [9680.7408] <4> ODBCDataSource::isInstalled: INF - ODBC Driver: SQL Server is installed on the system
16:21:36.955 [9680.7408] <4> getServerName: Read server name from nb_master_config: master.hostname
16:21:36.955 [9680.7408] <4> CDBIniParms::CDBIniParms: INF - NT User is domain.user
16:21:36.970 [9680.7408] <4> CGlobalInformation::CreateDSN: INF - Using ODBC Driver <SQL Server Native Client 11.0>
16:21:36.970 [9680.7408] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_temp_9680_7408_1>, SQL userid <sa> handle <0x005388c0>.
16:21:36.986 [9680.7408] <4> CGlobalInformation::CreateDSN: INF - A successful connection to SQL Server <target.hostname\target.instance> has been made using standard security with DSN <NBMSSQL_temp_9680_7408_1>
16:21:36.986 [9680.7408] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x005388c0>
16:21:36.986 [9680.7408] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_temp_9680_7408_1>, SQL userid <sa> handle <0x00538ff0>.
16:21:37.002 [9680.7408] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00538ff0>
16:21:37.002 [9680.7408] <4> CGlobalInformation::DeleteDSN: INF - Using ODBC Driver <SQL Server Native Client 11.0>
16:22:05.956 [9680.7408] <4> SQLEnumerator: INF - Enumerated SQL hosts: SERVER:Server={};UID:Login ID=?;PWD:Password=?;Trusted_Connection:Use Integrated Security=?;*APP:AppName=?;*WSID:WorkStation ID=?;
16:22:05.956 [9680.7408] <4> SQLEnumerator: INF - Could not enumerate SQL hosts with SQLBrowseConnectW
16:22:05.956 [9680.7408] <4> CGlobalInformation::IsDefaultInstanceInstalled: INF - Error: ERROR_FILE_NOT_FOUND
16:22:05.956 [9680.7408] <1> CGlobalInformation::IsDefaultInstanceInstalled: CONTINUATION: - The system cannot find the file specified.
16:22:05.956 [9680.7408] <4> CGlobalInformation::SQLEnumerator: INF - Hosts and instances retrieved from host list string
16:22:05.956 [9680.7408] <4> CGlobalInformation::SQLEnumerator: INF - host: target.hostname
16:22:05.956 [9680.7408] <4> CGlobalInformation::SQLEnumerator: INF - instance: target.instance
16:22:05.956 [9680.7408] <8> AugmentInstanceList: WARN - Cannot query <HKLM\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\\InstalledInstances> on <\\target.hostname>. Status <2>
16:22:05.956 [9680.7408] <1> AugmentInstanceList: CONTINUATION: - The system cannot find the file specified.
16:22:33.207 [9680.7408] <4> getServerName: Read server name from nb_master_config: master.hostname
16:22:36.316 [9680.7408] <4> StartupProcess: INF - Starting: <C:\Program Files\Veritas\NetBackup\bin\admincmd\bppllist.exe -byclient target.hostname>
16:22:46.317 [9680.7408] <16> StartupProcess: ERR - Timed out waiting for process to end : <C:\Program Files\Veritas\NetBackup\bin\admincmd\bppllist.exe -byclient target.hostname>.
16:22:46.317 [9680.7408] <1> StartupProcess: CONTINUATION: - The system cannot find the file specified.
16:22:46.317 [9680.7408] <8> CDBbackupView::ClassDropDownList: WARN - Error in StartupProcess: Command String: C:\Program Files\Veritas\NetBackup\bin\admincmd\bppllist.exe -byclient target.hostname
16:22:46.317 [9680.7408] <8> CBatchDlg::OnInitDialog: WARN - Policy Dropdown not created: Server = master.hostname Client = target.hostname
16:22:46.317 [9680.7408] <1> CBatchDlg::OnInitDialog: CONTINUATION: - The process cannot access the file because it is being used by another process.

[Marianne]

Is MSSQL properly installed on alternate client and SQL services up and running?

Before you attempt another restore - can you run a backup of the default databases on the destination client?

[Michael_G_Ander]

Have you given the alternate SQL client access to the original SQL clients backups within the altnames directory ?

I have always created the script from alternate SQL client to make sure it access the backups

Also a difference between using shortname and full qualified domain name can give things like this.