Backups are failing -- Need help to troubleshoot

Question

Backups are failing -- Need help to troubleshoot

ramana3327

SSCoach

Points: 19700
More actions
April 30, 2016 at 3:49 pm

#400096

Hello experts,
We are facing the issue backups are failing and not able to find the cause
We have SQL Server 2014 running and has Reporting Services running which is physical box.
They are converting physical to virtual. They created virtual machine and did SAN Backup or clone of the physical box.
The SQL Server jobs all are created. We have backup job to the shared path running through SP and overwiting daily. The backup job is failing in the virtual machine.
The steps I followed to troubleshoot the isse
1) Drop and created the backup job
2) Running the backup job manually other than scheduled time
3) Try to take the indiviaully database backup to local and network path (Database backup is terminating abnormallY)
4) If we run the job as it is it is failing bckup database is terminating abnormally [SQLSTATTE 420000] Error 3013
Any help would be appreciate
4) Created maintenance plan and run the job (Terminated abnormally)

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

VastSQL SSC-Dedicated Points: 36067 More actions · Answer 1

ramana3327 (4/30/2016)
Hello experts,
We are facing the issue backups are failing and not able to find the cause
We have SQL Server 2014 running and has Reporting Services running which is physical box.
They are converting physical to virtual. They created virtual machine and did SAN Backup or clone of the physical box.
The SQL Server jobs all are created. We have backup job to the shared path running through SP and overwiting daily. The backup job is failing in the virtual machine.
The steps I followed to troubleshoot the isse
1) Drop and created the backup job
2) Running the backup job manually other than scheduled time
3) Try to take the indiviaully database backup to local and network path (Database backup is terminating abnormallY)
4) If we run the job as it is it is failing bckup database is terminating abnormally [SQLSTATTE 420000] Error 3013
Any help would be appreciate
4) Created maintenance plan and run the job (Terminated abnormally)

1.Are you able to Manually take the backup successfully?

2. Does the SQL Service account have full right on the shared path to where you are taking backup?

Post the error you are receiving.

Jeff Moden SSC Guru Points: 1003853 More actions · Answer 2

ramana3327 (4/30/2016)
Hello experts,
We are facing the issue backups are failing and not able to find the cause
We have SQL Server 2014 running and has Reporting Services running which is physical box.
They are converting physical to virtual. They created virtual machine and did SAN Backup or clone of the physical box.
The SQL Server jobs all are created. We have backup job to the shared path running through SP and overwiting daily. The backup job is failing in the virtual machine.
The steps I followed to troubleshoot the isse
1) Drop and created the backup job
2) Running the backup job manually other than scheduled time
3) Try to take the indiviaully database backup to local and network path (Database backup is terminating abnormallY)
4) If we run the job as it is it is failing bckup database is terminating abnormally [SQLSTATTE 420000] Error 3013
Any help would be appreciate
4) Created maintenance plan and run the job (Terminated abnormally)

What is the full error message? If it's not in the job history, change the job steps to log to a file and read from that.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ramana3327 SSCoach Points: 19700 More actions · Answer 3

I am not able to take the successful backup manually.

Also it is generating dump files with access vilations whenever the backup is running either manually or scheduled

VastSQL SSC-Dedicated Points: 36067 More actions · Answer 4

ramana3327 (5/1/2016)
I am not able to take the successful backup manually.
Also it is generating dump files with access vilations whenever the backup is running either manually or scheduled

Post full error message here. Log the error to File as Jeff mentioned?

Did you check the permission on SQL service account to network path?

jeff.mason SSCrazy Eights Points: 9585 More actions · Answer 5

If you are seeing a failure to take a manual backup, it is almost certainly permissions based. Make sure the SQL Server service account is a domain account that has permissions to the file share, since it sounds like you are backing up over a network.

ramana3327 SSCoach Points: 19700 More actions · Answer 6

Yes, the service account has read\write & modify permissions on the shared path. We are using SQL Agent & Service account both are same.

jeff.mason SSCrazy Eights Points: 9585 More actions · Answer 7

Not sure from the last comment but just to clarify -- for backups it does not use the SQL Agent account but the SQL Server service account. If they are the same then that rules that out, but just something to look at.

Do you see anything on the Windows event logs for both the DB server and the file server at the same time? There should be some error there on one of the servers that is useful.

ramana3327 SSCoach Points: 19700 More actions · Answer 8

Thanks for all your suport.

Server restart resolved the issue

jeff.mason SSCrazy Eights Points: 9585 More actions · Answer 9

OK cool -- that means that the account got "confused" then.

ramana3327 SSCoach Points: 19700 More actions · Answer 10

You mean service account. Both are using same service account.