Hi Guna,
Open the Microsoft SQL Server Studio> Start>Programes>Microsoft SQL Server Stuido> Connect to the SAP Server Instance for which you want to take the Backup of the Database, then ->Server Object>Backup Devices--Rgiht Click on the Backup Devices -->give the location of the disk.
You can find this in your DB13 tcode.
<< This was posted by MNA earliar >>
Thanks & Regards,
Nagendra.
Dear Nagendra,
Thanks for your information, but we need to schedule at SAP level.
Kindly suggest me on this.
regards,
Guna
Hi Guna,
What is your backup media? Tape or Disk ?
If you want to take your backup to Disk, you can follow above procedure.
Above procedure is to schedule the backup through DB13 in disk.
If you your backup media is tape, you can select r3dump0 in your db13 tcode.
Thanks & Regards,
Nagendra.
Hi Nagendra,
My backup device is disk only but it is network drive. We have to schedule the backup on DB13 only.
Kindly suggest me on this.
regards,
Guna
My backup device is disk only but it is network drive
You can schedule your backup through DB13 and the backup file will happen in your network drive. Its possible follow the below procedure.
1) Are you able to share that particular drive? You should able to share.
2) Check whether that shared path you are able to access from your server
3) Configure a network drive in your server to ensure that there is no connectivity issues between your server and that path.
4) you need to configure that path in your management studio (Since your SQL should know the location of the disk.No issue Whether its local disk or network path)
5) Follow the below procedure to configure the location of disk in your SQL
6) After configuring, you can able to observe the same in DB13 along with R3DUMP0.
7) Try to schedule a log backup for test purpose.
Procedure
Open the Microsoft SQL Server Studio> Start>Programs>Microsoft SQL Server Studio> Connect to the SAP Server Instance for which you want to take the Backup of the Database, then ->Server Object>Backup Devices--Right Click on the Backup Devices -->give the location of the disk. here you need to give your network path
I hope this will help you.
Thanks & Regards,
Nagendra.
Hi Nagendra,
We tried that, but getting error,
SQL Job information ******************************
Jobname: SAP CCMS Full DB Backup of P10 [20091119172908-4-172908]
Type: TSQL
DB-Name: P10
For Run: 20091119 17:29:08
Job history information *****************************
Stepname: CCMS-step 1
Command: declare @exeStmt nvarchar(2000) exec p10.sap_backup_databases @dbList=
"P10",@r3Db="P10",@bDev="Disk",@expDays= 27,@jobName= "SAP CCMS Full D
B Backup of P10 [20091119172908-4-172908]",@bkupChecksum="N",@bkupType
="F",@nativeBkup="N",@exeDate = "20091119172908",@bkupSim = "N",@forma
t = 0,@init = 0,@bkupDb = "P10",@unload = 0,@exeStmt = @exeStmt OUTPUT
Status: (failure)
Message: 2528
Severity: 16
Duration: 0 hours(s) 0 min(s) 0 sec(s)
Last msg: Executed as user: NT AUTHORITY\SYSTEM. Cannot open backup device 'Disk
(
servername\Backup_SAP_servers)'. Operating system error 5(Access is
denied.). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminati
ng abnormally. [SQLSTATE 42000] (Error 3013) DBCC execution completed
. If DBCC printed error messages, contact your system administrator. [
SQLSTATE 01000] (Error 2528). The step failed.
<----
End of Job Step History -
>
Job history information *****************************
Suggest me for the above error message.
regards,
Guna
servername\Backup_SAP_servers)'. Operating system error 5(Access isdenied.)
Check whether you given full permissions for that network drive from your server.
Thanks & Regards,
Nagendra.
Hi Nagendra,
We don't have full permission, Read and Modify only provided. But from OS level I'm able to copy file to the target path.
regards,
Guna
HI All,
My backup device is disk only but it is network drive. We have to schedule the backup on DB13 only.
i m using DATABASE "DB2".
i am able to access the shared path from the server.
& Configured a network drive in the server.
Please help me with the same...
regards,
Ashish
