Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Sql Backup failing with error 6 <Please help>

Updated: 21 May 2010 | 6 comments
Debasishchoudhury@gmail.com's picture
0 0 Votes
Login to vote
Hi 

my os in 2008

Platform Operating System   OS Bit Agent                             Version DB Bit   Start of Support
x64          Windows 2008             32 Microsoft SQL Server      2005        32                    6.5.3

 
 

sql log
---------

OPERATION BACKUP
OBJECTTYPE DATABASE
DATABASE [master]
MAXTRANSFERSIZE 0
BLOCKSIZE 7
POLICY GS_SQL_DB_WCOSAPSMB
DBMS MSSQL
ENDOPER TRUE
 
INF - BACKUP STARTED USING
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
Nov 24 2008 13:01:59
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 6.0 (Build 6002: Service Pack 2)
Batch = C:\temp\master_LVL0.bch, Op# = 1
INF - Using backup image WCOSAPSM.MSSQL7.WCOSAPSM.db.master.~.7.001of001.20090825234940..C
INF - backup database "master" to VIRTUAL_DEVICE='VNBU0-5760-4712-1251265781' with  stats = 10, blocksize = 65536, maxtransfersize = 65536, buffercount = 1
INF - Number of stripes: 1, Number of buffers per stripe 1.
INF - Created VDI object for SQL Server instance <WCOSAPSM>. Connection timeout is <300> seconds.
Backup started Tue Aug 25 23:49:42 2009
 
ERR - Error in VxBSACreateObject: 3.
    CONTINUATION: - System detected error, operation aborted.
ERR - Error in VDS->Close: 0x80770004.
    CONTINUATION: - An abort request is preventing anything except termination actions.
INF - OPERATION #1 of batch C:\temp\master_LVL0.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 1392(0) seconds.
INF - Results of executing <C:\temp\master_LVL0.bch>:
<0> operations succeeded. <1> operations failed.
INF - The following object(s) were not backed up successfully.
INF – master
 
discussion Filed Under:

Comments

skarve's picture
26
Aug
2009
0 Votes 0
Login to vote

 Hello,     Can you check the

 Hello,
    Can you check the reverse lookup from client to master server?
try the nslookup and see if you can resolve name and IP from client to master (and vice versa)

Is the file system backup working?

Thanks
Sumeet.Karve

Matt Alexander's picture
26
Aug
2009
0 Votes 0
Login to vote

SQL Policy

This KB article might be what you're looking for: http://seer.entsupport.symantec.com/docs/289856.htm.

Also look into what skarve suggested.

Thanks,
Matt

If a post answered your question, please "Mark As Solution".

Abesama's picture
26
Aug
2009
0 Votes 0
Login to vote

Check dbclient log

<install_path>\NetBackup\logs\dbclient log will give you more information for your troubleshooting

don't forget to set the debug logging level to maximum

Anger Management

nairdheeraj's picture
27
Aug
2009
0 Votes 0
Login to vote

SA account

Can you also check if the SA account that you have used has access to the DB?

sumanreddy's picture
27
Aug
2009
0 Votes 0
Login to vote

Hi can you please send event

Hi

can you please send event logs at the time of Backup job failed.

Regards,
Suman

se7en's picture
27
Aug
2009
0 Votes 0
Login to vote

netbackup service

Is the netbackup service using a named account?