Forum Discussion

Dollypee's avatar
Dollypee
Moderator
11 years ago

Errors backing up SQL Database

Client :                       Win 2012 standard enterprise SQL server version :     2012 Master server version:  7.6.0.1 Client version:            7.6.0.1 Log on credentials permmisions...
  • Marianne's avatar
    11 years ago


    I do not have this issues with SQL server 2008 using the same permmisions above. Wondering if there's something different in 2012 that am not aware of. 

    It has to do with security/permissions applied by SQL dba, not with SQL version.

    Ask SQL dba to change NBU Client Service Account to same account that is used to start MS-SQL services.

  • pri3006's avatar
    11 years ago

    Since the NBU client server seems to be running under the LSA (NT AUTHORITY\SYSTEM), this technote may answer your question:

    http://www.symantec.com/docs/HOWTO85432

    An excerpt from the aforementioned technote:

    **************

    For SQL Server 2008 and earlier, the sysadmin role is automatically applied to the NT AUTHORITY\SYSTEM and BUILTIN\Administrators groups. You can use Local System for the logon accounts for the NetBackup services.

    For SQL Server 2012, you must first apply the sysadmin role manually to the NT AUTHORITY\SYSTEM or the BUILTIN\Administrators group. Then you can use Local System for the logon accounts for the NetBackup services.

    **************

  • NBU35's avatar
    11 years ago

    Try to run batch file for this backup from client and check if its running ?

    NBU MSSQL AGENT> File> manage script files  to run that batch file.
     

    if backup runs successfully then try following:

    use domain accout having admin privilages to start netbackup client service and netbackup legacy network services.

    Also create a role in MS SQL with sysadmin privilages and connect to instance to backup SQL objects using this user and then try to run the backup.