backup sql server management studio

[billel_kebadji]

Hello, 

I want to make backup for database in sql server management studio, but I have a problem during execution a file .bch

4/18/2016 1:04:12 PM - Info nbjm(pid=6588) starting backup job (jobid=167837) for client alg-sql01, policy ALG-SQL01, schedule HorsysAt14h  
4/18/2016 1:04:12 PM - Info nbjm(pid=6588) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=167837, request id:{D3582A81-7D53-4603-9A4D-8E9B4F623FE4})  
4/18/2016 1:04:12 PM - requesting resource EDriveStorageUnit
4/18/2016 1:04:12 PM - requesting resource alg-netbackup.nestle-waters.dz.NBU_CLIENT.MAXJOBS.alg-sql01
4/18/2016 1:04:12 PM - requesting resource alg-netbackup.nestle-waters.dz.NBU_POLICY.MAXJOBS.ALG-SQL01
4/18/2016 1:04:12 PM - granted resource alg-netbackup.nestle-waters.dz.NBU_CLIENT.MAXJOBS.alg-sql01
4/18/2016 1:04:12 PM - granted resource alg-netbackup.nestle-waters.dz.NBU_POLICY.MAXJOBS.ALG-SQL01
4/18/2016 1:04:12 PM - granted resource EDriveStorageUnit
4/18/2016 1:04:12 PM - estimated 0 Kbytes needed
4/18/2016 1:04:12 PM - Info nbjm(pid=6588) started backup (backupid=alg-sql01_1460981052) job for client alg-sql01, policy ALG-SQL01, schedule HorsysAt14h on storage unit EDriveStorageUnit
4/18/2016 1:04:13 PM - Info bpbrm(pid=9684) alg-sql01 is the host to backup data from     
4/18/2016 1:04:13 PM - Info bpbrm(pid=9684) reading file list for client        
4/18/2016 1:04:13 PM - started process bpbrm (9684)
4/18/2016 1:04:13 PM - connecting
4/18/2016 1:04:14 PM - Info bpbrm(pid=9684) starting bphdb on client         
4/18/2016 1:04:14 PM - connected; connect time: 0:00:01
4/18/2016 1:04:14 PM - Info bphdb(pid=4132) Backup started           
4/18/2016 1:04:16 PM - Info dbclient(pid=4164) INF - BACKUP STARTED USING        
4/18/2016 1:04:16 PM - Info dbclient(pid=4164) Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)     
4/18/2016 1:04:16 PM - Info dbclient(pid=4164) Oct 19 2012 13:38:57         
4/18/2016 1:04:16 PM - Info dbclient(pid=4164) Copyright (c) Microsoft Corporation         
4/18/2016 1:04:16 PM - Info dbclient(pid=4164) Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor) 
4/18/2016 1:04:16 PM - Info dbclient(pid=4164) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SAM8-SansCompression.bch, Op# = 1      
4/18/2016 1:04:17 PM - Info dbclient(pid=4164) INF - Using backup image ALG-SQL01.MSSQL7.ALG-SQL01.db.SAM8.~.7.001of001.20160418130415..C       
4/18/2016 1:04:17 PM - Info dbclient(pid=4164) INF - backup database "SAM8" to VIRTUAL_DEVICE='VNBU0-4164-1568-1460981057' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
4/18/2016 1:04:17 PM - Info dbclient(pid=4164) INF - Number of stripes: 1, Number of buffers per stripe 2. 
4/18/2016 1:04:17 PM - Info dbclient(pid=4164) INF - Created VDI object for SQL Server instance <ALG-SQL01>. Connection timeout is <300> seconds.
4/18/2016 1:09:18 PM - Info dbclient(pid=4164) ERR - Error in GetConfiguration: 0x80770003.       
4/18/2016 1:09:18 PM - Info dbclient(pid=4164)     CONTINUATION: - The api was waiting and the timeout interval had elapsed.
4/18/2016 1:09:18 PM - Info dbclient(pid=4164) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <18210><[Microsoft][ODBC SQL Server Driver][SQL Server]BackupVirtualDeviceSet::Initialize: CoCreateInstance failure on backup device 'VNBU0-4164-1568-1460981057'. Operating system error 0x80070005(Access is denied.).>.
4/18/2016 1:09:18 PM - Info dbclient(pid=4164) DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.>
4/18/2016 1:09:18 PM - Info dbclient(pid=4164) ERR - Error found executing <backup database "SAM8" to VIRTUAL_DEVICE='VNBU0-4164-1568-1460981057' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
4/18/2016 1:09:19 PM - Info dbclient(pid=4164) ERR - Error in VDS->Close: 0x80770004.       
4/18/2016 1:09:19 PM - Info dbclient(pid=4164)     CONTINUATION: - An abort request is preventing anything except termination actions.
4/18/2016 1:09:19 PM - Info dbclient(pid=4164) INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SAM8-SansCompression.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 304(304) seconds.
4/18/2016 1:09:21 PM - Info dbclient(pid=4164) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SAM8-SansCompression.bch>:      
4/18/2016 1:09:21 PM - Info dbclient(pid=4164) <0> operations succeeded. <1> operations failed.       
4/18/2016 1:09:22 PM - Info dbclient(pid=4164) INF - The following object(s) were not backed up successfully.   
4/18/2016 1:09:22 PM - Info dbclient(pid=4164) INF - SAM8          
4/18/2016 1:09:22 PM - Error bpbrm(pid=9684) from client alg-sql01: ERR - command failed: none of the requested files were backed up (2)
4/18/2016 1:09:22 PM - Error bpbrm(pid=9684) from client alg-sql01: ERR - bphdb exit status = 2: none of the requested files were backed up
4/18/2016 1:09:22 PM - Info bphdb(pid=4132) done. status: 2: none of the requested files were backed up  
4/18/2016 1:09:22 PM - end writing
none of the requested files were backed up(2)

can you help me to find the problem.

[Will_Restore]

Default timeout of 300 seconds is too low.  Insert this line into your .bch file and retry the job.

VDITIMEOUTSECONDS 900

[Michal_Mikulik1]

Hello,

you cannot backuprestore to/from Netbackup via SQL Management Studio.You must use NetBackup for MS SQL interface or dbbackex command.

Regards

Michal

[billel_kebadji]

I followed your instructions:

4/18/2016 2:07:13 PM - Info nbjm(pid=6588) starting backup job (jobid=167861) for client alg-sql01, policy ALG-SQL01, schedule HorsysAt14h  
4/18/2016 2:07:13 PM - Info nbjm(pid=6588) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=167861, request id:{A631CE6F-09FA-4B9F-BDAD-B665E26EF7CC})  
4/18/2016 2:07:13 PM - requesting resource EDriveStorageUnit
4/18/2016 2:07:13 PM - requesting resource alg-netbackup.nestle-waters.dz.NBU_CLIENT.MAXJOBS.alg-sql01
4/18/2016 2:07:13 PM - requesting resource alg-netbackup.nestle-waters.dz.NBU_POLICY.MAXJOBS.ALG-SQL01
4/18/2016 2:07:13 PM - granted resource alg-netbackup.nestle-waters.dz.NBU_CLIENT.MAXJOBS.alg-sql01
4/18/2016 2:07:13 PM - granted resource alg-netbackup.nestle-waters.dz.NBU_POLICY.MAXJOBS.ALG-SQL01
4/18/2016 2:07:13 PM - granted resource EDriveStorageUnit
4/18/2016 2:07:14 PM - estimated 0 Kbytes needed
4/18/2016 2:07:14 PM - Info nbjm(pid=6588) started backup (backupid=alg-sql01_1460984833) job for client alg-sql01, policy ALG-SQL01, schedule HorsysAt14h on storage unit EDriveStorageUnit
4/18/2016 2:07:14 PM - Info bpbrm(pid=10004) alg-sql01 is the host to backup data from     
4/18/2016 2:07:14 PM - Info bpbrm(pid=10004) reading file list for client        
4/18/2016 2:07:14 PM - started process bpbrm (10004)
4/18/2016 2:07:14 PM - connecting
4/18/2016 2:07:15 PM - Info bpbrm(pid=10004) starting bphdb on client         
4/18/2016 2:07:15 PM - connected; connect time: 0:00:01
4/18/2016 2:07:16 PM - Info bphdb(pid=4624) Backup started           
4/18/2016 2:07:18 PM - Info dbclient(pid=2404) INF - BACKUP STARTED USING        
4/18/2016 2:07:18 PM - Info dbclient(pid=2404) Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)     
4/18/2016 2:07:18 PM - Info dbclient(pid=2404) Oct 19 2012 13:38:57         
4/18/2016 2:07:18 PM - Info dbclient(pid=2404) Copyright (c) Microsoft Corporation         
4/18/2016 2:07:18 PM - Info dbclient(pid=2404) Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor) 
4/18/2016 2:07:18 PM - Info dbclient(pid=2404) Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SAM8-SansCompression.bch, Op# = 1      
4/18/2016 2:07:18 PM - Info dbclient(pid=2404) INF - Using backup image ALG-SQL01.MSSQL7.ALG-SQL01.db.SAM8.~.7.001of001.20160418140717..C       
4/18/2016 2:07:18 PM - Info dbclient(pid=2404) INF - backup database "SAM8" to VIRTUAL_DEVICE='VNBU0-2404-4784-1460984838' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2
4/18/2016 2:07:18 PM - Info dbclient(pid=2404) INF - Number of stripes: 1, Number of buffers per stripe 2. 
4/18/2016 2:07:19 PM - Info dbclient(pid=2404) INF - Created VDI object for SQL Server instance <ALG-SQL01>. Connection timeout is <900> seconds.
4/18/2016 2:22:19 PM - Info dbclient(pid=2404) ERR - Error in GetConfiguration: 0x80770003.       
4/18/2016 2:22:19 PM - Info dbclient(pid=2404)     CONTINUATION: - The api was waiting and the timeout interval had elapsed.
4/18/2016 2:22:20 PM - Info dbclient(pid=2404) DBMS MSG - ODBC return code <-1>, SQL State <37000>, SQL Message <18210><[Microsoft][ODBC SQL Server Driver][SQL Server]BackupVirtualDeviceSet::Initialize: CoCreateInstance failure on backup device 'VNBU0-2404-4784-1460984838'. Operating system error 0x80070005(Access is denied.).>.
4/18/2016 2:22:20 PM - Info dbclient(pid=2404) DBMS MSG - SQL Message <3013><[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.>
4/18/2016 2:22:20 PM - Info dbclient(pid=2404) ERR - Error found executing <backup database "SAM8" to VIRTUAL_DEVICE='VNBU0-2404-4784-1460984838' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2>.
4/18/2016 2:22:20 PM - Info dbclient(pid=2404) ERR - Error in VDS->Close: 0x80770004.       
4/18/2016 2:22:21 PM - Info dbclient(pid=2404)     CONTINUATION: - An abort request is preventing anything except termination actions.
4/18/2016 2:22:21 PM - Info dbclient(pid=2404) INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SAM8-SansCompression.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 904(904) seconds.
4/18/2016 2:22:23 PM - Info dbclient(pid=2404) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\SAM8-SansCompression.bch>:      
4/18/2016 2:22:23 PM - Info dbclient(pid=2404) <0> operations succeeded. <1> operations failed.       
4/18/2016 2:22:23 PM - Info dbclient(pid=2404) INF - The following object(s) were not backed up successfully.   
4/18/2016 2:22:23 PM - Info dbclient(pid=2404) INF - SAM8          
4/18/2016 2:22:23 PM - Error bpbrm(pid=10004) from client alg-sql01: ERR - command failed: none of the requested files were backed up (2)
4/18/2016 2:22:23 PM - Error bpbrm(pid=10004) from client alg-sql01: ERR - bphdb exit status = 2: none of the requested files were backed up
4/18/2016 2:22:24 PM - Info bphdb(pid=4624) done. status: 2: none of the requested files were backed up  
4/18/2016 2:22:24 PM - end writing
none of the requested files were backed up(2)

Other solution !!

[Michal_Mikulik1]

Hello,

please clarify how you use "sql server managemenr studio" with yor backups. As I said it is not supported. Your scipt looks like traditional .bch launched within NetBackup MS SQL Agent interface, not within SQL Management Studio.

VDI timeout errors are usually caused by another confliciting BACKUP DATABASE process on the same database. Review MS SQL instance processes and if any other processes like this, kill them.

Regards

Michal

[billel_kebadji]

Hello Michal, 

Yes my script is launched within NetBackup MYSQL Agent interface and not with sql server managemenr studio, 

are there any better approaches !!

best regards

[Will_Restore]

2 things:

Operating system error 0x80070005(Access is denied.)

To resolve this issue, make sure all SQL Instances are using the same service account to run.  

In addition, make sure this account has sufficient NTFS permissions to access the SQL database files. 

https://www.veritas.com/support/en_US/article.TECH59280

==

Connection timeout is <900> seconds.
CONTINUATION: - The api was waiting and the timeout interval had elapsed.

Client is quite slow. Try increasing VDITIMEOUT to 1800 or 2400.

[Marianne]

Please check for hanging dbbackex processes on the client. If no backup is running, there should be none of these in running processes. Kill any hung dbbackex processes. In addition to checking SQL service accounts, also check that NBU Client Service account is running with sufficient SQL permissions, not Local System. Please show us your .bch script. I am curious about the reference to compression...

[billel_kebadji]

Hello, 

In Netbackup Client Service run with Administrator local in Windows server 2012 R2 standard, and i use symantec netbackup 7.6.0.2

OPERATION BACKUP
DATABASE "SAM8"
SQLHOST "ALG-SQL01"
NBSERVER "ALG-NETBACKUP"
VDITIMEOUTSECONDS 1800
MAXTRANSFERSIZE 6
BLOCKSIZE 7
NUMBUFS 2
ENDOPER TRUE

[Marianne]

NBU Client Service account needs SQL admin rights. Please review the TN in Will's post as well.

[NBU35]

Hi 

Please check following things:

1) Account which you are using for SQL backups, that should be member of "BulitIN Administrator" group and should have "sysadmin" privilages in MS SQL.

2) start Netbackup client services & netbackup Legacy Network services with this log in account.

3) open SQL management studio> open activity monitor in SQL management STudio > under Process tab >> comamnd > check if there is any comamnd of type "backup" or "backup databse" or "backup logs".

if yes, right click and kill . then retry the backup.

if this does not solve your issue, then check event logs> application and see if there are any error/warning events realted to MSSQL.