SQL Policy

Debasishchoudhu · ‎08-26-2009

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

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

skarve · ‎08-26-2009

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 · ‎08-26-2009

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

Abesama · ‎08-26-2009

<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

nairdheeraj · ‎08-27-2009

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

sumanreddy · ‎08-27-2009

Hi

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

Regards,
Suman

se7en · ‎08-27-2009

Is the netbackup service using a named account?

VOX

Sql Backup failing with error 6 <Please help>