Video Screencast Help

MSSQL Agent - Filesystem errors

Created: 08 May 2012 | 14 comments

Hi.

We have the  following problem running BE 2010R3 SP2.

When backing up MSSQL Express 2005 SP4 on two machines (HP DL380 G7) after that the filesystem on the partition where the database is located is getting corrupted (CHKDSK shows errors and need to be run in read/write mode on startup to correct them).

This is absolutely reproducable and happens every time the DBs are backed up.

When we removed the machines from backup they run without any probem for days, when we put them back into the backup jobs filesystem is corrupted after the backup ran.

We also checked to backup the partition where the DBs are location without selecting the agent and activating VSS which works flawlessly. As soon as we select them via MSSQL from within BE problem reappears.

Any suggestions what's going wrong here?

BTW: We already had a call open with HP which checked all HW and FW versions, but were not able to find any problem and stated that everything is correct.

Thanks.

Cheers.

 

 

Comments 14 CommentsJump to latest comment

Backup_Exec's picture

Hi

 

If you backup your SQL databases using SQL studio , does the same behaviour happen , that your file system is corrupted if not could you please check that

Also try seprating the backup of SQL & file system, were SQL backup should be backed up without AOFO & for filesystem backup you can use AOFO if required

If issue still persist you can also look for events in events viewer after backup is done on SQL server to see realted events in terms of error, warning and information

 

Thanks

 

Sameer

Don't forget to give a "Thumbs Up" or Mark as "Solution" if someones advice has helped you.

harsi's picture

Ok doing a backup from within SQLStudio does not corrupt the filesystem, it only happens when doing a backup via BE SQLAgent.

Just to make it clear again.

This happens reproducably every time and on all machines.

Maybe a good idea to drop BE SQLAgent for now.

Cheers.

pkh's picture

How are you backing up your SQL Express databases?  Using the SQL agent?

harsi's picture

We are trying to backup SQL using BE SQLAgent.

We already tried doing SQLBackup job for it's own with AOFO disabled without success.

Event Logs do not show any errors.

Doing the same from within Studio we did no try but will do so and post results.

Cheers.

pkh's picture

Since the problem is reproducible, you should open a formal support case for it to be looked at. 

madlalan's picture

i'm installing backup exec 2012 and when it gets to sql express it fails with extraction failed " access is denied"

Ben L.'s picture

Harsi,

If possible, can you open a support ticket for this issue, we would like to look at it a bit more closely.

Thanks,

If this response answers your concern, please mark it as a "solution"

harsi's picture

JFYI.

We opened a support case more than two month ago, however still now solution.

Here it is absolutely reproducable on different machines also with the smallest possible SQL database and only happens when using the BE MSSQL agent for backup. When using MS tools for backup or use BE without agent (VSS based backup) no problem at all.

Symantec support reproduced it here via remote session and also seemed to quite surprised/confused.

Last time I heared from them is more than two weeks ago.

Cheers.

CraigV's picture

...to be honest, I wouldn't wait 2 weeks...call them back and ask them for an update or an escalation.

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

pkh's picture

Why don't you send Ben L. a PM with our case number and ask him to take a look?

Ben L.'s picture

That would be me.  Private message me the case number and I'll look into the issue.

I'm one of the 3rd level tech's that monitors the forums from time to time. smiley

If this response answers your concern, please mark it as a "solution"

harsi's picture

Hi.

Another month has passed without any reaction from Symantec's side.

The customer is getting quite angry meanwhile and want's to drop BE altogehter.

Sorry to say but what I have seen from Symantec regarding support here is exceptional.