Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

SQL Backup issue

Created: 14 Jan 2013 • Updated: 15 Jan 2013 | 2 comments
This issue has been solved. See solution.

 

Client netbackup 6.5.5
and master server 7.5
 
Microsoft SQL Server  2000 - 8.00.2039 (Intel X86) 
 
May  3 2005 23:18:38 
 
Copyright (c) 1988-2003 Microsoft Corporation
 
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) 
 
Batch = SQLNEW.bch, Op# = 4
13:28:36.742 [2732.1616] <4> InitPipeInfo: INF - Using backup image aesql.MSSQL7.AESQL.db.EchoDB.~.7.001of001.20130114132835..C
13:28:36.742 [2732.1616] <4> Dbbackrec::CreateSQLcmdSyntax: INF - backup database "EchoDB" to VIRTUAL_DEVICE='VNBU0-2732-1616-1358162916' with blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
13:28:36.742 [2732.1616] <4> Dbbackrec::CreateSQLcmdSyntax: INF - Number of stripes: 1, Number of buffers per stripe 2.
13:28:36.742 [2732.1616] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_2732_4944_4>, SQL userid <sa> handle <0x00ea1a20>.
13:28:36.742 [2732.1616] <4> CDBbackrec::InitDeviceSet(): INF - Created VDI object for SQL Server instance <aesql>. Connection timeout is <300> seconds.
13:28:36.773 [2732.4752] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:28:36.773 [2732.4752] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:28:36.992 [2732.4752] <2> logconnections: BPRD CONNECT FROM 10.210.10.63.2791 TO 10.210.210.174.13724
13:33:36.747 [2732.1616] <16> CDBbackrec::InitDeviceSet_Part2(): ERR - Error in GetConfiguration: 0x80770003.
13:33:36.747 [2732.1616] <1> CDBbackrec::InitDeviceSet_Part2():     CONTINUATION: - The api was waiting and the timeout interval had elapsed.
13:33:36.747 [2732.1616] <4> KillAllThreads: INF - Killing group #0
13:33:36.747 [2732.1616] <4> KillAllThreads: INF - Issuing SignalAbort to MS SQL Server VDI
13:33:36.747 [2732.2900] <4> KillAllThreads: INF - Killing group #0
13:33:36.779 [2732.4752] <4> KillAllThreads: INF - Killing group #0
13:33:36.779 [2732.2512] <4> KillAllThreads: INF - Killing group #0
13:33:36.779 [2732.1616] <16> CODBCaccess::LogODBCerr: DBMS MSG - ODBC return code <-1>, SQL State <08004>, SQL Message <916><[Microsoft][ODBC SQL Server Driver][SQL Server]Server user 'NT AUTHORITY\SYSTEM' is not a valid user in database 'EchoDB'.>.
13:33:36.779 [2732.1616] <16> CODBCaccess::LogODBCerr: DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.>
13:33:36.779 [2732.1616] <16> Dbbackrec::PerformNBOperation: ERR - Error found executing <backup database "EchoDB" to VIRTUAL_DEVICE='VNBU0-2732-1616-1358162916' with blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
13:33:36.779 [2732.1616] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00ea1a20>
13:33:36.779 [2732.1616] <4> getServerName: Read server name from nb_master_config: ae-bkp
13:33:36.810 [2732.1616] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2048: VN_REQUEST_SERVICE_SOCKET: 6 0x00000006
13:33:36.810 [2732.1616] <2> vnet_vnetd_service_socket: ..\libvlibs\vnet_vnetd.c.2062: service: bprd
13:33:37.044 [2732.1616] <2> logconnections: BPRD CONNECT FROM 10.210.10.63.2828 TO 10.210.210.174.13724
13:33:39.185 [2732.1616] <16> CDBbackrec::FreeDeviceSet(): ERR - Error in VDS->Close: 0x80770004.
13:33:39.185 [2732.1616] <1> CDBbackrec::FreeDeviceSet():     CONTINUATION: - An abort request is preventing anything except termination actions.
Discussion Filed Under:

Comments 2 CommentsJump to latest comment

Marianne's picture

Server user 'NT AUTHORITY\SYSTEM' is not a valid user in database 'EchoDB'.>.

Go through SQL Server privileges as well as Setting the SQL Server login for scheduled operations in NBU for SQL manual with your SQL DBA.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Dyneshia's picture

1) 6.x had been end of life since OCT : http://www.symantec.com/docs/TECH74757

  You need to upgrade as soon as possible.

Confirm your OS and SQL versions are certified with Netbackup

http://www.symantec.com/docs/TECH59978 - NetBackup Master Compatibility List

NetBackup 7 Application/Database Agent (CL):    http://www.symantec.com/docs/TECH126904

2) <08004>, SQL Message <916><[Microsoft][ODBC SQL Server Driver][SQL Server]Server user 'NT AUTHORITY\SYSTEM' is not a valid user in database 'EchoDB'.>.

Please note that when the NetBackup scheduler is used, backup operations that are launched from a daemon process called the NetBackup Client Service. You must ensure that the Client Service has SQL Server privileges to perform backup and restore operations. If you use integrated security, you must ensure that the NetBackup Client Service specifies a Windows account that has been granted SQL Server administrative privileges.

In short, any account that will be used to access the SQL databases for backup and restores (this can the the native SQL 'sa' account; a Windows global account; or the default 'LocalSystem' account) MUST be a member of the SQL > Security > 'sysadmin' role; otherwise, NBU will not have sufficient privileges to backup and restore SQL databases.

I have included below links to a number of Symantec documents that detail the setup of the SQL server security and other important details on the most common NBU SQL Agent operations.

 

HOWTO69788: About setting the SQL Server logon for scheduled operations
-> www.symantec.com/business/support/index?page=conte...

TECH39418: DOCUMENTATION: How to configure Veritas NetBackup (tm) for backups and restores of Microsoft SQL Server
-> www.symantec.com/business/support/index?page=conte...

TECH43698: Documentation: How to run NetBackup for Microsoft SQL Server Backups using "Local System Account" for the NetBackup Client Service
-> http://www.symantec.com/business/support/index?pag...

TECH74475: A comprehensive list of solutions for the most common NetBackup for Microsoft SQL Server database agent backup and restore issues
-> http://www.symantec.com/business/support/index?pag...

 

3) Do you see errors in the application or system event viewer on the SQL server ?

 

SOLUTION