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 1:14 AM |  Mark as helpful |
Hi david
i have just tryed to take backup...
when i m selecting R3DUMP1 DIVICE NAME. its giving the error.
System.Data.SqlClient.SqlError: Cannot open backup device
'R3DUMP1(\\.\tape1)'. Operating system error 2(The system cannot find the
file specified.). (Microsoft.SqlServer.Smo)
TAPE Is Tandberg ts400
thnaks
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 have just tryed to take backup...
when i m selecting R3DUMP1 DIVICE NAME. its giving the error.
System.Data.SqlClient.SqlError: Cannot open backup device
'R3DUMP1(\\.\tape1)'. Operating system error 2(The system cannot find the
file specified.). (Microsoft.SqlServer.Smo)
TAPE Is Tandberg ts400
thnaks
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
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
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
_.____.__ 
