Reg : Log Back up

[Former Member]

Dear Friends,

1.Today morning i took Log Back up. But i show error msg is FINISHED WITH ERROR this type of error.

DB - MS SQL Server 2005

OS - Windows 2003 Server

SAP - ECC 6.0 SR2

What can i do? How can i rectify this problem.

2. Yesterday i scheduled Full Database backup. It is also got error msg same Finished with error.

ERROR LOGS

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

Jobname: SAP CCMS Log Backup of PRD [20090512090126-2-090126]

Type: TSQL

DB-Name: PRD

For Run: 20090512 09:01:26

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

Stepname: CCMS-step 1

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

"PRD",@r3Db="PRD",@bDev="R3DUMP0",@expDays= 27,@bkupChecksum="N",@jobN

ame= "SAP CCMS Log Backup of PRD [20090512090126-2-090126]",@bkupType=

"L",@nativeBkup="N",@exeDate = "20090512090126",@bkupSim = "N",@format

= 0,@init = 0,@bkupDb = "PRD",@unload = 0,@exeStmt = @exeStmt OUTPUT

Status: (failure)

Message: 3013

Severity: 16

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

Last msg: Executed as user: NT AUTHORITY\SYSTEM. DBCC execution completed. If DB

CC printed error messages, contact your system administrator. [SQLSTAT

E 01000] (Message 2528) BACKUP LOG cannot be performed because there

is no current database backup. [SQLSTATE 42000] (Error 4214) BACKUP L

OG is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step

failed.

<----

---

End of Job Step History -

---

>

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

Regards

kesav

[Former Member · Accepted solution]

In SQL server you can't take a log backup unless you have full backup

So try doing full backup first,take the backup of all the 4 databases and then run the log backup,also schedule a offline backup that will be better

Also let us know the errors that you get if any while running the full backup

Rohit

[Former Member · Accepted solution]

Hi Rohit,

My Schedule of Full Db is yesterday 23.00 PM in 11.05.2009(Night)

but LOG BAck UP is today 9.00 AM in 12.05.2009(Now Day time).

Then how can i know SAPROUTER will started? pls tell me rohit.

Regards

kesavan

[Former Member · Accepted solution]

SAP ROUTER????

from where does this comes into picture,what system backup are you taking???

please clear

what I am saying is take a full DB backup of your SAP system which includes all the 4 database backup i.e master,model.Temp DB and SAP

Rohit

[Former Member · Accepted solution]

Dear Rohith,

Action : Full Database

Planned Start : 11.05.2009 time : 23.00.00

Status : Finished with Error

Action started : 11.05.2009 : 23:00:00

Action Finished : 12.05,2009 : 00.11.54

Backup software : . Native SQl Backup

Database : 1. Master

2. Msdb

3. SID(SAP DB)

Select Backup Device for backup : R3DUMP0

Regards

kesav

[Former Member · Accepted solution]

Include Model database backup also

and please tell the error logs?what do they say and what about SAP router that you were talking

Rohit

[Former Member · Accepted solution]

Hi Rohith,

I have screen Shot if i have ur personnel id (like yahoo, or Gmail) give me

I send screen shot to u.

Regards

kesav

[Former Member · Accepted solution]

I think it will be better if you post the logs

exchanging and communicationg on emails-ids over the forums is against the rules

Rohit

[Former Member · Accepted solution]

Dear Rohith,

I am first started SAP router and show this msges. So i don't know wheather SAP router started or not?

When i started SAP router that messages saw in the dos prompt screen. this below msg what is this?

C:\saprouter>saprouter -r -K "p:CN=solmanager, OU=0000824350, OU=SAProuter, O=SAP, C=DE"

trcfile dev_rout

no logging active

Warning : wildcard character used in route target

regards

kesavan

[Former Member · Accepted solution]

but how is SAP router related to your backup

but whatever the logs that you show it indicates that SAP router has started

Rohit

[Former Member · Accepted solution]

Dear Rohith,

It is not related Backup. This is another issue rohith. i check SM59 RFC Connections to OSS notes but SNC processing failed. what can i do?

Regards

kesavan.

[Former Member · Accepted solution]

Hello Keshav,

In that case I would suggest you open a new question in the forum,

Only one question per thread,please follow the rules of forum

Rohit

[Former Member · Accepted solution]

Hi Rohith

I raised separate queries.

Regards

kesav

[Former Member]

i didn't get exact answer. So i flag down my issue.