MS-SQL database backup fails with status 1 when 'SQLINSTANCE $ALL' is used in the batch file and the database instances belong to different versions of MS-SQL server.

Problem

MS-SQL server version 2000 and 2005 uses diffferent syntax to query the databases.

Error Message

5/8/2012 10:34:12 AM - Info dbclient(pid=6592) DBMS MSG - ODBC return code <-1>, SQL State <S0002>, SQL Message <208><[Microsoft][SQL Native Client][SQL Server]Invalid object name 'master.sys.database_files'.>

Cause

MS-SQL server version 2000 and 2005 uses diffferent syntax to query the databases. So, putting 'SQLINSTANCE $ALL' in the batch file used in the policy to backup databases belonging to different versions of MS-SQL servers causes this problem.

Solution

Any of the followings work for the above situation:

1. Use three different batch files to avoid 'SQLINSTANCE $ALL' and to use the instance names against each 'SQLINSTANCE' card.

2. Use two NetBackup policies, one to use a batch file with 'SQLINSTANCE $ALL' to backup MS-SQL 2005 server as the client, the other to backup MS-SQL 2000 server as the client.

 


Applies To

NetBackup MS-SQL Database Agent

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)