cancel
Showing results for 
Search instead for 
Did you mean: 

Database Back Up error In SQL Server

Former Member
0 Kudos

Hi SAP GURUS,

I am facing the the backup related issues in production server

BRTOOLS is also not working in the system as it is not showing the EXE file in Usr/SAP/SID/...

So mean while we are taking backup manually !!!

My OS is Windows 2003 Server and Database is Microsoft SQL Server.

After hitting DB13 when we go for Full database Backup .

10011 Access denied.

Message no. SMMSS_SQLJOBS000

An error occurred when processing system GCP

Message no. DB6PM220

Function DB6_PLAN_EXEC_BATCH failed with return Code = Job Error

Message no. DB6PM005

And also have checked the backend Configuration in DB13 its perfectly fine.

Guys Please Help me out in solving this Issue ..

Accepted Solutions (0)

Answers (2)

Answers (2)

sivakumar_kilari3
Active Contributor
0 Kudos

Follow this thread.

Note 1115746 - Tape device not found

Regards

Siva

Edited by: Siva K Kumar on Mar 10, 2011 3:18 PM

Former Member
0 Kudos

Hi thanks for the update.

But i have checked using through forum you have posted but the error is not being resolved

Can u let me know what other steps to be taken care in backend configuration !!!

Regards

Vishal

markus_doehr2
Active Contributor
0 Kudos

You can "access denied" - that means, that the user trying to access the tape device is not permitted to do so.

Can you do backups from SQL Server Management Studio?

Is the user SAPService<SID> in the backup operator group?

Markus

Former Member
0 Kudos

Markus,

Wel i can take the backup from SQL server management Studio.

but through SAP was not able to take the back up

still working on that !!!

Every day we are taking the Manual backup both through NT backup and Server management Studio ..

Regards

Vishal

sivakumar_kilari3
Active Contributor
0 Kudos

Hi Vishal,

What is your SAP version and BASIS support package level?

Siva

markus_doehr2
Active Contributor
0 Kudos

You can try to find the problem using

Note 166861 - Analysis of DB13 problems

and also stays the question, whether the user SAPService<SID> is in the Backup Operator group.

Markus

Former Member
0 Kudos

Hi All,

Well i have gone through the Management Studio. I am Able to take the Backup manualy but not able to take the make through SAP !!

As suggested Earlier I will check the SAP serviceSID and will update you accordingly..

Regards

Vishal

ganesh_borase2
Participant
0 Kudos

Hi Vishal,

Try to take backup using the new tape.

Thanks

Ganesh

Former Member
0 Kudos

Ganesh,

Thanks for the help

Well i have already done that before too. I have also check the ServiceSAP file and also the permission but dont know what issue is coming I am not able to trace down the Issue.

As soon i click the db13 and go for full database backup and select the tape its shows access denied. What is happening in the background cant able to trace out...

So planning to lock the complain to SAP ..

Regards

Vishal Arora

markus_doehr2
Active Contributor
0 Kudos

> BRTOOLS is also not working in the system as it is not showing the EXE file in Usr/SAP/SID/...

BRTOOLS is for Oracle _only*.

> And also have checked the backend Configuration in DB13 its perfectly fine.

Where are you try to backup to? Tape device? Network drive?

Markus

Former Member
0 Kudos

Markus,

Tape Drive !!!