Re: [sap-basis] Differential Database Transaction Log Backup working full database backup not completed
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Sadiq (SAP BASIS Consultant) on Apr 15 at 2:08 AM |  Mark as helpful |
Hi David
I forgot to mention one thing...yesterday i have taken backup with option
SID(SAP DB). ITS sucsessful.
but when i m selecting remaining 2 MASTER & MSDB. is failing.
as we have 3 option MASTER, MSDB AND SID(SAPDB).
THANKS
SADIQ
On Thu, Apr 15, 2010 at 1:33 AM, D. Caddick via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:
>
> Posted by D. Caddick (SAP
> NetWeaver/BASIS Consultant)
> on Apr 14 at 4:02 PM
> Ok, so have you tried performing a backup using the SQL Server Management
> Studio.
>
>
>
>
>
> From: Sadiq via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
> Sent: 14 April 2010 19:43
> To: D. Caddick
> Subject: Re: [sap-basis] Differential Database Transaction Log Backup
> working full database backup not completed
>
>
>
>
>
>
>
>
> Posted by Sadiq (SAP BASIS
> Consultant)
> on Apr 14 at 2:41 PM
>
> <http://it.toolbox.com/api/ContentVote/3439673/1/1/> Mark this reply as
> helpfulMark as helpful
>
> Hi Caddik
>
> i was a old log.. which was sucsesfully completed.
>
> after this when i tryed next time it got failed.
>
> thats the issue.
>
> thanks
>
>
>
> On Thu, Apr 15, 2010 at 12:02 AM, D. Caddick via sap-basis <
> sap-basis@groups.ittoolbox.com> wrote:
>
> >
> > Posted by D. Caddick (SAP
> > NetWeaver/BASIS Consultant)
> > on Apr 14 at 2:34 PM
> > Hi Sadiq,
> >
> > It seems the full backup is now successfull. Nor double clisn on the
> Backup
> > device R3DUMP0 to try and read the contents.
> >
> > Regards
> >
> > ---------------Original Message---------------
> > From: Sadiq
> > Sent: Wednesday, April 14, 2010 9:48 AM
> > Subject: Differential Database Transaction Log Backup working full
> database
> > backup not completed
> >
> > > Dear Experts,
> > > I am Using ECC6 with SQL server 2005 on windows 2003 server,
> > >
> > > When i am taking backup with db13 my Differential Database and
> > Transaction Log Backup working fine.
> > >
> > > but when i am taking full data base backup it got failed. full database
>
> > backup program log is as bellow.
> > >
> > >
> > > SQL Job information
> > > Jobname: SAP CCMS Full DB Backup of master,msdb,PRD
> > [20100414124631-3-124631]
> > > Type: TSQL
> > > DB-Name: PRD
> > > For Run: 20100414 12:46:31
> > > Job history information
> > > Stepname: CCMS-step 1
> > > Command: declare @exeStmt nvarchar(2000) exec prd.sap_backup_databases
> > @dbList "master,msdb,PRD",@r3Db="PRD",@bDev="R3DUMP0",@exp Days=
> > 27,@bkupChecks
> > > um="Y",@jobName= "SAP CCMS Full DB Backup of master,msdb,PRD [20100414
> > > 124631-3-124631]",@bkupType="F",@nativeBkup="N",@ex eDate = "2010041412
>
> > > 4631",@bkupSim = "N",@format = 1,@init = 1,@bkupDb = "master",@unload
> > > = 0,@exeStmt = @exeStmt OUTPUT
> > > Status: (success)
> > > Message: 3014
> > > Severity: 0
> > > Duration: 0 hours(s) 0 min(s) 12 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) Processed 376 pages for database 'master', fi
> > > le 'master' on file 1. [SQLSTATE 01000] (Message 4035) Processed 2 pa
> > > ges for database 'master', file 'mastlog' on file 1. [SQLSTATE 01000]
> > > (Message 4035) BACKUP DATABASE successfully processed 378 pages in 8.
> > > 963 seconds (0.345 MB/sec). [SQLSTATE 01000] (Message 3014). The step
> > > succeeded.
> > > End of Job Step History
> > >
> > > Stepname: CCMS-step 2
> > > Command: declare @exeStmt nvarchar(2000) exec prd.sap_backup_databases
> > @dbList "master,msdb,PRD",@r3Db="PRD",@bDev="R3DUMP0",@exp Days=
> > 27,@bkupChecks
> > > um="Y",@jobName= "SAP CCMS Full DB Backup of master,msdb,PRD [20100414
> > > 124631-3-124631]",@bkupType="F",@nativeBkup="N",@ex eDate = "2010041412
>
> > > 4631",@bkupSim = "N",@bkupDb = "msdb",@unload = 0,@exeStmt = @exeStmt
> > > OUTPUT
> > > Status: (failure)
> > > Message: 3013
> > > Severity: 16
> > > Duration: 0 hours(s) 0 min(s) 18 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 file on device 'R3DUMP0(\\.\tape0)' is no
> > > t a valid Microsoft Tape Format backup set. [SQLSTATE 42000] (Error 32
> > > 42) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Erro
> > > r 3013). The step failed.
> > > End of Job Step History
> > >
> > > Stepname: CCMS-step 3
> > > Command: declare @exeStmt nvarchar(2000) exec prd.sap_backup_databases
> > @dbList "master,msdb,PRD",@r3Db="PRD",@bDev="R3DUMP0",@exp Days=
> > 27,@bkupChecks
> > > um="Y",@jobName= "SAP CCMS Full DB Backup of master,msdb,PRD [20100414
> > > 124631-3-124631]",@bkupType="F",@nativeBkup="N",@ex eDate = "2010041412
>
> > > 4631",@bkupSim = "N",@bkupDb = "PRD",@unload = 1,@exeStmt = @exeStmt O
> > > UTPUT
> > > 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 file on device 'R3DUMP0(\\.\tape0)' is no
> > > t a valid Microsoft Tape Format backup set. [SQLSTATE 42000] (Error 32
> > > 42) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Erro
> > > r 3013). The step failed.
> > > End of Job Step History Job history information
> > >
> > > Kindly guide me regarding.
> > >
> > > thanks
> > >
> > > sadiq
__.____._ I forgot to mention one thing...yesterday i have taken backup with option
SID(SAP DB). ITS sucsessful.
but when i m selecting remaining 2 MASTER & MSDB. is failing.
as we have 3 option MASTER, MSDB AND SID(SAPDB).
THANKS
SADIQ
On Thu, Apr 15, 2010 at 1:33 AM, D. Caddick via sap-basis <
sap-basis@groups.ittoolbox.com> wrote:
>
> Posted by D. Caddick (SAP
> NetWeaver/BASIS Consultant)
> on Apr 14 at 4:02 PM
> Ok, so have you tried performing a backup using the SQL Server Management
> Studio.
>
>
>
>
>
> From: Sadiq via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
> Sent: 14 April 2010 19:43
> To: D. Caddick
> Subject: Re: [sap-basis] Differential Database Transaction Log Backup
> working full database backup not completed
>
>
>
>
>
>
>
>
> Posted by Sadiq (SAP BASIS
> Consultant)
> on Apr 14 at 2:41 PM
>
> <http://it.toolbox.com/api/ContentVote/3439673/1/1/> Mark this reply as
> helpfulMark as helpful
>
> Hi Caddik
>
> i was a old log.. which was sucsesfully completed.
>
> after this when i tryed next time it got failed.
>
> thats the issue.
>
> thanks
>
>
>
> On Thu, Apr 15, 2010 at 12:02 AM, D. Caddick via sap-basis <
> sap-basis@groups.ittoolbox.com> wrote:
>
> >
> > Posted by D. Caddick (SAP
> > NetWeaver/BASIS Consultant)
> > on Apr 14 at 2:34 PM
> > Hi Sadiq,
> >
> > It seems the full backup is now successfull. Nor double clisn on the
> Backup
> > device R3DUMP0 to try and read the contents.
> >
> > Regards
> >
> > ---------------Original Message---------------
> > From: Sadiq
> > Sent: Wednesday, April 14, 2010 9:48 AM
> > Subject: Differential Database Transaction Log Backup working full
> database
> > backup not completed
> >
> > > Dear Experts,
> > > I am Using ECC6 with SQL server 2005 on windows 2003 server,
> > >
> > > When i am taking backup with db13 my Differential Database and
> > Transaction Log Backup working fine.
> > >
> > > but when i am taking full data base backup it got failed. full database
>
> > backup program log is as bellow.
> > >
> > >
> > > SQL Job information
> > > Jobname: SAP CCMS Full DB Backup of master,msdb,PRD
> > [20100414124631-3-124631]
> > > Type: TSQL
> > > DB-Name: PRD
> > > For Run: 20100414 12:46:31
> > > Job history information
> > > Stepname: CCMS-step 1
> > > Command: declare @exeStmt nvarchar(2000) exec prd.sap_backup_databases
> > @dbList "master,msdb,PRD",@r3Db="PRD",@bDev="R3DUMP0",@exp Days=
> > 27,@bkupChecks
> > > um="Y",@jobName= "SAP CCMS Full DB Backup of master,msdb,PRD [20100414
> > > 124631-3-124631]",@bkupType="F",@nativeBkup="N",@ex eDate = "2010041412
>
> > > 4631",@bkupSim = "N",@format = 1,@init = 1,@bkupDb = "master",@unload
> > > = 0,@exeStmt = @exeStmt OUTPUT
> > > Status: (success)
> > > Message: 3014
> > > Severity: 0
> > > Duration: 0 hours(s) 0 min(s) 12 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) Processed 376 pages for database 'master', fi
> > > le 'master' on file 1. [SQLSTATE 01000] (Message 4035) Processed 2 pa
> > > ges for database 'master', file 'mastlog' on file 1. [SQLSTATE 01000]
> > > (Message 4035) BACKUP DATABASE successfully processed 378 pages in 8.
> > > 963 seconds (0.345 MB/sec). [SQLSTATE 01000] (Message 3014). The step
> > > succeeded.
> > > End of Job Step History
> > >
> > > Stepname: CCMS-step 2
> > > Command: declare @exeStmt nvarchar(2000) exec prd.sap_backup_databases
> > @dbList "master,msdb,PRD",@r3Db="PRD",@bDev="R3DUMP0",@exp Days=
> > 27,@bkupChecks
> > > um="Y",@jobName= "SAP CCMS Full DB Backup of master,msdb,PRD [20100414
> > > 124631-3-124631]",@bkupType="F",@nativeBkup="N",@ex eDate = "2010041412
>
> > > 4631",@bkupSim = "N",@bkupDb = "msdb",@unload = 0,@exeStmt = @exeStmt
> > > OUTPUT
> > > Status: (failure)
> > > Message: 3013
> > > Severity: 16
> > > Duration: 0 hours(s) 0 min(s) 18 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 file on device 'R3DUMP0(\\.\tape0)' is no
> > > t a valid Microsoft Tape Format backup set. [SQLSTATE 42000] (Error 32
> > > 42) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Erro
> > > r 3013). The step failed.
> > > End of Job Step History
> > >
> > > Stepname: CCMS-step 3
> > > Command: declare @exeStmt nvarchar(2000) exec prd.sap_backup_databases
> > @dbList "master,msdb,PRD",@r3Db="PRD",@bDev="R3DUMP0",@exp Days=
> > 27,@bkupChecks
> > > um="Y",@jobName= "SAP CCMS Full DB Backup of master,msdb,PRD [20100414
> > > 124631-3-124631]",@bkupType="F",@nativeBkup="N",@ex eDate = "2010041412
>
> > > 4631",@bkupSim = "N",@bkupDb = "PRD",@unload = 1,@exeStmt = @exeStmt O
> > > UTPUT
> > > 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 file on device 'R3DUMP0(\\.\tape0)' is no
> > > t a valid Microsoft Tape Format backup set. [SQLSTATE 42000] (Error 32
> > > 42) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Erro
> > > r 3013). The step failed.
> > > End of Job Step History Job history information
> > >
> > > Kindly guide me regarding.
> > >
> > > thanks
> > >
> > > sadiq
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
SadiqSAP Basis Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Did this response help you resolve your issue? Click the green 'Mark as helpful' arrow to vote on the entry.
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
