Browsing articles in "Symantec Netbackup"
Aug
29
2013

Transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds

While dealing with a rollback/kill process (in SQL Server 2005 SP4 + CU3 environment) which is stuck for more than 10 days, it was a VERITAS NetBackup (DB tape backup) process,     On checking the DMV’s dm_exec_requests and dm_exec_sessions using below query, SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT db_id(DB_NAME(er.[database_id])) [DBID] ,er.[session_id] AS [SessionID] ,er.[command] AS [CommandType] ,est.[text] [StatementText] ,er.[status] AS [Status] ,CONVERT(DECIMAL(5, 2), er.[percent_complete]) AS [Complete_Percent] ,CONVERT(DECIMAL(38, 2), er.[total_elapsed_time] / 60000.00) AS [ElapsedTime_m] […]

May
10
2013

NetBackup ERR – Error in VxBSADeterminePolicy: 26 and ERR – Error in CryptAcquireContext : 2148073508

Kind of unique issue faced today, SQL Server backup job was continuously failing (with ERROR(-1) and exit status 2) to take database backups on Symantec NetBackup Utility. In GUI console following error was logged in,   USER – Verify that an active SQL Server policy exists for this client. ERR – Error in VxBSADeterminePolicy: 26. CONTINUATION: – There is no copy of the requested object.   This is not first time we were running backup, […]

May
7
2013

Troubleshooting NetBackup Issues and Error Exit Codes

While working with Symantec NetBackup utility for SQL Server encountered several errors where backups are hanging in middle or failing with absurd error codes, below are some useful references and links which helps in troubleshooting such errors,   1. VDI related error:   Error message 1 2007-06-18 11:21:00.83 spid820 BackupVirtualDeviceFile::ClearError: failure on backup device ‘VDI_DeviceID‘. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). Error […]

May
7
2013

How to use RETRY option in Symantec NetBackup for SQL Server

While working with Symantec NetBackup utility for SQL Server came across Retry option, this helps in reducing manual effort spend in retrying failed backups, but in some scenarios there is certain overhead as well, below is brief info about this option,   How Retry Parameter works for SQL Server Backups   If you like to setup NetBackup to retry failed backups automatically then you can use following three parameters along with other, RETRYTYPE AUTO        #This parameter […]

Feb
26
2013

Using EXCLUDE in NetBackup .bch script –SQL Server database backups

I was searching for a solution to exclude specific database from Symantec NetBackup .bch script for SQL Server database backups, there are two ways to excluded databases,   1. By using EXCLUDE parameter As per admin guide, Name of a database to exclude when DATABASE $ALL is specified in a batch operation EXCLUDE can be used in a batch file only if DATABASE $ALL is used.   Following is sample .bch file with some example […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 23 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

November 2017
M T W T F S S
« Oct    
 12345
6789101112
13141516171819
20212223242526
27282930  

View Post by Categories

%d bloggers like this: