A restore of a SQL Server database fails with Status Code 5, or Error (-1), when the host name of the SQL Server or the SQL Server database name has trailing spaces
When the host name of a SQL Server or a SQL Server database name has one or more trailing spaces, NetBackup does not generate the restore script correctly. The trailing spaces in the SQL Server host name or the database name are truncated in the script. To successfully perform a restore, you must create and edit a restore script in the NetBackup MS SQL Client.
In the script, edit the DATABASE and the NBIMAGE lines to include the correct SQL Server host name or SQL Server database name. For example, assume that the server host name is "ACCT", you use the default instance, and that the database name is "DatabaseA". Notice the trailing spaces after the server host name and the database name.
Change the following lines:
DATABASE "DatabaseA" NBIMAGE "ACCT.MSSQL7.ACCT.db.DatabaseA.~.7.001of001.20151118121736..C"
To:
DATABASE "DatabaseA" NBIMAGE "ACCT.MSSQL7.ACCT.db.DatabaseA.~.7.001of001.20151118121736..C"