Online Database Problem

[ganesh_borase2]

Hello Everybody,

i have been trying to take Database Backup( Database is -SQL 2005) on the tape. i execute the T.code DB13 then schedule for the same, backup option- Full backup, also tape initialize. But Execute the Job on scheduled time it generate Error as follows

• SQL Job information ******************************

Jobname: SAP CCMS Full DB Backup of master,RPD [20090620094326-6-094326]

Type: TSQL

DB-Name: RPD

For Run: 20090620 09:43:26

• Job history information *****************************

Stepname: CCMS-step 1

Command: declare @exeStmt nvarchar(2000) exec rpd.sap_backup_databases @dbList=

"master,RPD",@r3Db="RPD",@bDev="R3DUMP0",@expDays= 27,@jobName= "SAP C

CMS Full DB Backup of master,RPD [20090620094326-6-094326]",@bkupCheck

sum="N",@bkupType="F",@nativeBkup="N",@exeDate = "20090620094326",@bku

pSim = "N",@format = 0,@init = 1,@bkupDb = "master",@unload = 0,@exeSt

mt = @exeStmt OUTPUT

Status: (failure)

Message: 2528

Severity: 16

Duration: 0 hours(s) 0 min(s) 12 sec(s)

Last msg: Executed as user: NT AUTHORITY\SYSTEM. Access is denied due to a password failure [SQLSTATE 42000] (Error 3279) BACKUP DATABASE is terminat

ing abnormally. [SQLSTATE 42000] (Error 3013) DBCC execution complete

d. If DBCC printed error messages, contact your system administrator.

[SQLSTATE 01000] (Error 2528). The step failed.

<----

---

End of Job Step History -

---

>

• Job history information *****************************

So i execute the Job by log -<SID>adm.

So please suggest me how to take backup on tape. Can i change the windows OS user from <SID>adm to administrator

Thanks

Ganesh

[Former Member · Accepted solution]

Hi Ganesh,

It seems to be an authorization issue . Probably your SQL Server service is running by a domain

account . Try to login with this account and run the job .

Also let me know whether your <SID>ADM is a domain user or not .

Regards,

Nibu

[ganesh_borase2 · Accepted solution]

Hi Nibu,

SQL service is running in Windows Authentication Mode, and not by domain account.

I have mention that i have log on to the window by <SID>adm account and Also error

Thanks

Ganesh

[Former Member · Accepted solution]

Hi,

You have to ensure that the SQL Server service (which is performing the backup) has enough rights to

perform the activity . To ensure this, start the SQL Server with an account (Right click on service >

Properties and change user ) that has enough rights on the domain (domain user with write rights on

the tape).

Then you should be able to perform a backup via DB13 to this device .

Regards,

Nibu

[ganesh_borase2 · Accepted solution]

Hi,

if a user has a SAP_ALL authorization, then he will be able to schedule the Database backup using DB13. when i execute the Backup from the SAP using the Db13. but i have been suffer from the error

• SQL Job information ******************************

Jobname: SAP CCMS Full DB Backup of master,RPD [20090620094326-6-094326]

Type: TSQL

DB-Name: RPD

For Run: 20090620 09:43:26

• Job history information *****************************

Stepname: CCMS-step 1

Command: declare @exeStmt nvarchar(2000) exec rpd.sap_backup_databases @dbList=

"master,RPD",@r3Db="RPD",@bDev="R3DUMP0",@expDays= 27,@jobName= "SAP C

CMS Full DB Backup of master,RPD [20090620094326-6-094326]",@bkupCheck

sum="N",@bkupType="F",@nativeBkup="N",@exeDate = "20090620094326",@bku

pSim = "N",@format = 0,@init = 1,@bkupDb = "master",@unload = 0,@exeSt

mt = @exeStmt OUTPUT

Status: (failure)

Message: 2528

Severity: 16

Duration: 0 hours(s) 0 min(s) 12 sec(s)

Last msg: Executed as user: NT AUTHORITY\SYSTEM. Access is denied due to a password failure [SQLSTATE 42000] (Error 3279) BACKUP DATABASE is terminat

ing abnormally. [SQLSTATE 42000] (Error 3013) DBCC execution complete

d. If DBCC printed error messages, contact your system administrator.

[SQLSTATE 01000] (Error 2528). The step failed.

<----

---

End of Job Step History -

---

>

• Job history information *****************************

So please suggest me how to do?

Also on OS using use <SID>adm, i have open the SQL server Management studion., and try to open the Media Contents then generate the error message cannot open backup device 'R3DUMP0(
.\tape0)', operating system error 2 (the system cannot find the file specified)

Thanks

Ganesh

[Former Member · Accepted solution]

Hi Ganesh,

It is not related with the SAP_ALL permission, means SAP level permission.

Please login as the OS admin and check whether you can execute the backup manually from SQL

Management studio . Also it seems the tape drive is not detected and that causes the error specified in

bottom. Please check wnether you have installed it properly . Also check the note Note 37152 - SQL

Server Backup to a dump file and it will be helpful.

Regards,

Nibu