How many files are created during SAP Full database backup

[Former Member]

Well i executed Full database backup

i have few question

1. The output of SAP Full backup is only one file or more files as i have only one file called filename.bak aftre backup from SAP?

3. Is it a online backup cause i thought it will shutdown the system automatically but it was kind of online backup.

2. I am not sure if Fullbackup executed succesfully, it created backup in one file called DBNOV.bak

below is the detail of DB12 output, DB13 and error log

in DB12 it shows its successfully executed with code ok.

in DB13 PREVIEW tab here is the log it shows

exec msdb..sp_add_job @originating_server = '(local)',@job_name = "SAP CCMS Full DB Backup of

SID 20081112160619-3-173000",@enabled = 1,@description = "SAP CCMS JOB",@start_step_id = 1,

@category_name = NULL,@category_id = NULL

exec msdb..sp_add_jobstep @job_id = null,@job_name = 'SAP CCMS Full DB Backup of SID

20081112160619-3-173000',@step_id = 1,@step_name = 'CCMS-step 1',@subsystem =

'TSQL',@command = 'declare @exeStmt nvarchar(2000) exec sid.sap_backup_databases

@dbList="SID",@r3Db="SID",@bDev="USBDB",@expDays= 27,@bkupChecksum="N",@jobName= "SAP CCMS

Full DB Backup of SID 20081112160619-3-173000",@bkupType="F",@nativeBkup="N",@exeDate =

"20081112173000",@bkupSim = "Y",@format = 0,@init = 0,@bkupDb = "SID",@unload = 0,@exeStmt =

@exeStmt OUTPUT',@database_name = 'SID',@on_success_action = 3

BACKUP DATABASE SID TO USBDB WITH

DESCRIPTION = 'SAP CCMS Full DB Backup of SID 20081112160619-3-173000',RETAINDAYS=27,

NOINIT,

NAME = 'Sap backup on 20081112 21:27:40',NOUNLOAD

exec msdb..sp_add_jobstep @job_id = null,@job_name = 'SAP CCMS Full DB Backup of SID

20081112160619-3-173000',@step_id = 2,@step_name = 'CCMS-step 2',@subsystem =

'TSQL',@command = 'declare @exeStmt nvarchar(2000) exec sid.sap_verify_backups @nativeBkup =

"N",@bkupSim = "Y",@bDev = "USBDB",@bkupChecksum = "N",@exeDate = "20081112173000",@unload =

0,@dbCnt =1,@exeStmt = @exeStmt OUTPUT',@database_name = 'SID'

RESTORE VERIFYONLY FROM USBDB WITH FILE = X ,NOUNLOAD

exec msdb..sp_add_jobschedule @job_id = null,@job_name = 'SAP CCMS Full DB Backup of SID

20081112160619-3-173000',@name = 'CCMS-sche1',@enabled = 1,@freq_type =1,@freq_interval =

1,@freq_subday_type = 0,@freq_subday_interval = 0,@active_start_date =

20081112,@active_start_time = 173000,@freq_recurrence_factor = 0

here is the log file snapshot

2008-11-12 17:30:01.42 spid83 DBCC TRACEON 3605, server process ID (SPID) 83. This is an informational message only; no user action is required.

2008-11-12 18:21:59.35 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:21:59.35 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:21:59.62 spid85 Error: 18204, Severity: 16, State: 1.

2008-11-12 18:21:59.62 spid85 BackupDiskFile::OpenMedia: Backup device 'E:\SAPMSQLbackup\DBNOV.bak' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).

2008-11-12 18:22:09.73 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:22:09.73 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:22:09.85 spid85 Error: 18204, Severity: 16, State: 1.

2008-11-12 18:22:09.85 spid85 BackupDiskFile::OpenMedia: Backup device 'E:\SAPMSQLbackup\DBNOV.bak' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).

2008-11-12 18:24:05.09 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:24:05.09 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:24:05.18 spid85 Error: 18204, Severity: 16, State: 1.

2008-11-12 18:24:05.18 spid85 BackupDiskFile::OpenMedia: Backup device 'E:\SAPMSQLbackup\DBNOV.bak' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).

2008-11-12 18:24:07.40 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:24:07.40 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:24:07.56 spid85 Error: 18204, Severity: 16, State: 1.

2008-11-12 18:24:07.56 spid85 BackupDiskFile::OpenMedia: Backup device 'E:\SAPMSQLbackup\DBNOV.bak' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).

2008-11-12 18:24:09.03 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:24:09.03 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:24:09.15 spid85 Error: 18204, Severity: 16, State: 1.

2008-11-12 18:24:09.15 spid85 BackupDiskFile::OpenMedia: Backup device 'E:\SAPMSQLbackup\DBNOV.bak' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).

2008-11-12 18:24:11.51 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:24:11.51 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:24:11.65 spid85 Error: 18204, Severity: 16, State: 1.

2008-11-12 18:24:11.65 spid85 BackupDiskFile::OpenMedia: Backup device 'E:\SAPMSQLbackup\DBNOV.bak' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).

2008-11-12 18:25:08.59 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:25:08.61 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:25:20.51 spid89 DBCC TRACEON 3605, server process ID (SPID) 89. This is an informational message only; no user action is required.

2008-11-12 18:25:27.00 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:25:27.00 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:32:26.91 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:32:26.91 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:32:27.05 spid85 Error: 18204, Severity: 16, State: 1.

2008-11-12 18:32:27.05 spid85 BackupDiskFile::OpenMedia: Backup device 'E:\SAPMSQLbackup\DBNOV.bak' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).

2008-11-12 18:36:51.51 spid91 DBCC TRACEON 3605, server process ID (SPID) 91. This is an informational message only; no user action is required.

2008-11-12 18:36:51.51 spid91 DBCC TRACEON 3605, server process ID (SPID) 91. This is an informational message only; no user action is required.

2008-11-12 18:36:51.65 spid91 Error: 18204, Severity: 16, State: 1.

2008-11-12 18:36:51.65 spid91 BackupDiskFile::OpenMedia: Backup device 'E:\SAPMSQLbackup\DBNOV.bak' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).

2008-11-12 18:37:12.04 spid91 DBCC TRACEON 3605, server process ID (SPID) 91. This is an informational message only; no user action is required.

2008-11-12 18:37:12.04 spid91 DBCC TRACEON 3605, server process ID (SPID) 91. This is an informational message only; no user action is required.

2008-11-12 18:37:12.16 spid91 Error: 18204, Severity: 16, State: 1.

2008-11-12 18:37:12.16 spid91 BackupDiskFile::OpenMedia: Backup device 'E:\SAPMSQLbackup\DBNOV.bak' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).

2008-11-12 18:37:21.02 spid91 DBCC TRACEON 3605, server process ID (SPID) 91. This is an informational message only; no user action is required.

2008-11-12 18:37:21.04 spid91 DBCC TRACEON 3605, server process ID (SPID) 91. This is an informational message only; no user action is required.

2008-11-12 18:37:21.18 spid91 Error: 18204, Severity: 16, State: 1.

2008-11-12 18:37:21.18 spid91 BackupDiskFile::OpenMedia: Backup device 'E:\SAPMSQLbackup\DBNOV.bak' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).

2008-11-12 18:44:44.23 spid92 DBCC TRACEON 3605, server process ID (SPID) 92. This is an informational message only; no user action is required.

2008-11-12 18:45:24.42 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:45:24.42 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:45:24.42 spid85 Error: 18204, Severity: 16, State: 1.

2008-11-12 18:45:24.42 spid85 BackupDiskFile::OpenMedia: Backup device 'E:\SAPMSQLbackup\test.bak' failed to open. Operating system error 2(The system cannot find the file specified.).

2008-11-12 18:45:32.78 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:45:32.78 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:45:32.78 spid85 Error: 18204, Severity: 16, State: 1.

2008-11-12 18:45:32.78 spid85 BackupDiskFile::OpenMedia: Backup device 'E:\SAPMSQLbackup\test.bak' failed to open. Operating system error 2(The system cannot find the file specified.).

2008-11-12 18:45:39.70 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:45:39.70 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 18:45:39.84 spid85 Error: 18204, Severity: 16, State: 1.

2008-11-12 18:45:39.84 spid85 BackupDiskFile::OpenMedia: Backup device 'E:\SAPMSQLbackup\DBNOV.bak' failed to open. Operating system error 32(The process cannot access the file because it is being used by another process.).

2008-11-12 19:50:27.41 Backup Database backed up. Database: SID, creation date(time): 2008/05/07(18:32:21), pages dumped: 26905751, first LSN: 9854:10543:202, last LSN: 9854:18731:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'USBDB'}). This is an informational message only. No user action is required.

2008-11-12 19:50:27.55 spid83 DBCC TRACEON 3605, server process ID (SPID) 83. This is an informational message only; no user action is required.

2008-11-12 21:25:21.51 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 21:25:21.60 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 21:27:40.86 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

2008-11-12 21:27:40.86 spid85 DBCC TRACEON 3605, server process ID (SPID) 85. This is an informational message only; no user action is required.

exec msdb..sp_add_jobserver @job_name = 'SAP CCMS Full DB Backup of SID

20081112160619-3-173000',@server_name = '(local)'

thanks a lot for your time

Mani

[Former Member · Accepted solution]

>1. The output of SAP Full backup is only one file or more files as i have only one file called filename.bak aftre backup from SAP?

can you please check your backup configuration init<SID>.sap file

>3. Is it a online backup cause i thought it will shutdown the system automatically but it was kind of online backup.

you can schedule online/offline backup, if it is online then database wont go offline.

>2. I am not sure if Fullbackup executed succesfully, it created backup in one file called DBNOV.bak below is the detail of DB12 output, DB13 and error log

as per log doesnt look that the backup completed successfully.

cheers,

-Sunil

[Former Member · Accepted solution]

Hello Sunil,

well first of all my SAP serer is based on Windows with MSSQL 2005 as back-end.

Well on MSSQL based SAP there is no any Init<sid>.sap file.

and in DB13 its not clear if its online or offline backup. Its has only these options Full backup, Differential, transaction log and user DB are there.

in DB12 say successfully executed.

Here is DBA log detail

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

Jobname: SAP CCMS Full DB Backup of SID [20081112160619-3-173000]

Type: TSQL

DB-Name: SID

For Run: 20081112 17:30:00

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

Stepname: CCMS-step 1

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

"SID",@r3Db="SID",@bDev="USBDB",@expDays= 27,@bkupChecksum="N",@jobNam

e= "SAP CCMS Full DB Backup of SID [20081112160619-3-173000]",@bkupTyp

e="F",@nativeBkup="N",@exeDate = "20081112173000",@bkupSim = "N",@form

at = 0,@init = 0,@bkupDb = "SID",@unload = 0,@exeStmt = @exeStmt OUTPU

T

Status: (success)

Message: 3014

Severity: 0

Duration: 2 hours(s) 20 min(s) 26 sec(s)

Last msg: Executed as user: NT AUTHORITY\SYSTEM. ...act your system administrato

r. [SQLSTATE 01000] (Message 2528) Processed 3855904 pages for databa

se 'SID', file 'SIDDATA1' on file 1. [SQLSTATE 01000] (Message 4035)

Processed 3839096 pages for database 'SID', file 'SIDDATA2' on file 1.

[SQLSTATE 01000] (Message 4035) Processed 3846504 pages for database

'SID', file 'SIDDATA3' on file 1. [SQLSTATE 01000] (Message 4035) Pr

ocessed 3839160 pages for database 'SID', file 'SIDDATA4' on file 1. [

SQLSTATE 01000] (Message 4035) Processed 3840192 pages for database '

SID', file 'SIDDATA5' on file 1. [SQLSTATE 01000] (Message 4035) Proc

essed 3840888 pages for database 'SID', file 'SIDDATA6' on file 1. [SQ

LSTATE 01000] (Message 4035) Processed 3843392 pages for database 'EC

D', file 'SIDDATA7' on file 1. [SQLSTATE 01000] (Message 4035) Proces

sed 512 pages for database 'SID', file 'SIDLOG1' on file 1. [SQLSTATE

01000] (Message 4035) BACKUP DATABASE successfully processed 26905648

pages in 8417.144... The step succeeded.

<----

---

End of Job Step History -

---

>

Stepname: CCMS-step 2

Command: declare @exeStmt nvarchar(2000) exec SID.sap_verify_backups @nativeBku

p = "N",@bkupSim = "N",@bDev = "USBDB",@bkupChecksum = "N",@exeDate =

"20081112173000",@unload = 0,@dbCnt =1,@exeStmt = @exeStmt OUTPUT

Status: (success)

Message: 3262

Severity: 0

Duration: 1 hours(s) 45 min(s) 48 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) The backup set on file 1 is valid. [SQLSTATE

01000] (Message 3262). The step succeeded.

<----

---

End of Job Step History -

---

>

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

Mani

[Former Member · Accepted solution]

Hello Sunil,

well first of all my SAP serer is based on Windows with MSSQL 2005 as back-end.

Well on MSSQL based SAP there is no any Init<sid>.sap file.

and in DB13 its not clear if its online or offline backup. Its has only these options Full backup, Differential, transaction log and user DB are there.

in DB12 say successfully executed.

Here is DBA log detail

SQL Job information

Jobname: SAP CCMS Full DB Backup of SID [20081112160619-3-173000]

Type: TSQL

DB-Name: SID

For Run: 20081112 17:30:00

Job history information

Stepname: CCMS-step 1

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

"SID",@r3Db="SID",@bDev="USBDB",@expDays= 27,@bkupChecksum="N",@jobNam

e= "SAP CCMS Full DB Backup of SID [20081112160619-3-173000]",@bkupTyp

e="F",@nativeBkup="N",@exeDate = "20081112173000",@bkupSim = "N",@form

at = 0,@init = 0,@bkupDb = "SID",@unload = 0,@exeStmt = @exeStmt OUTPU

T

Status: (success)

Message: 3014

Severity: 0

Duration: 2 hours(s) 20 min(s) 26 sec(s)

Last msg: Executed as user: NT AUTHORITY\SYSTEM. ...act your system administrato

r. [SQLSTATE 01000] (Message 2528) Processed 3855904 pages for databa

se 'SID', file 'SIDDATA1' on file 1. [SQLSTATE 01000] (Message 4035)

Processed 3839096 pages for database 'SID', file 'SIDDATA2' on file 1.

[SQLSTATE 01000] (Message 4035) Processed 3846504 pages for database

'SID', file 'SIDDATA3' on file 1. [SQLSTATE 01000] (Message 4035) Pr

ocessed 3839160 pages for database 'SID', file 'SIDDATA4' on file 1. [

SQLSTATE 01000] (Message 4035) Processed 3840192 pages for database '

SID', file 'SIDDATA5' on file 1. [SQLSTATE 01000] (Message 4035) Proc

essed 3840888 pages for database 'SID', file 'SIDDATA6' on file 1. [SQ

LSTATE 01000] (Message 4035) Processed 3843392 pages for database 'EC

D', file 'SIDDATA7' on file 1. [SQLSTATE 01000] (Message 4035) Proces

sed 512 pages for database 'SID', file 'SIDLOG1' on file 1. [SQLSTATE

01000] (Message 4035) BACKUP DATABASE successfully processed 26905648

pages in 8417.144... The step succeeded.

<----

---

End of Job Step History -

---

>

Stepname: CCMS-step 2

Command: declare @exeStmt nvarchar(2000) exec SID.sap_verify_backups @nativeBku

p = "N",@bkupSim = "N",@bDev = "USBDB",@bkupChecksum = "N",@exeDate =

"20081112173000",@unload = 0,@dbCnt =1,@exeStmt = @exeStmt OUTPUT

Status: (success)

Message: 3262

Severity: 0

Duration: 1 hours(s) 45 min(s) 48 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) The backup set on file 1 is valid. [SQLSTATE

01000] (Message 3262). The step succeeded.

<----

---

End of Job Step History -

---

>

Job history information

Mani

[Former Member · Accepted solution]

as per log backup looks completed successfully.

for more details on your query follow http://help.sap.com/saphelp_nw70/helpdata/EN/f2/31ad41810c11d288ec0000e8200722/frameset.htm

cheers,

-Sunil