"borase" wrote:

> Hello everybody,
>    i have been suffer from problem that, I have installed the HP workstorage
> Ultrium 448 tape drive and able to take database backup using the NTBACKUP
> utility. When trying to take backup of  database from  SQL server 2005
> Manager, then it generate the Error
>
> ***************************** SQL Job information
> ******************************
> Jobname:    SAP CCMS Full DB Backup of master,RPD [20090620094326-6-094326]
> Type:       TSQL
> DB-Name:    RPD
> For Run:    20090620  09:43:26
> **************************** Job history information
> *****************************
> Stepname:   CCMS-step 1
> Command:    declare @exeStmt nvarchar(2000) exec rpd.sap_backup_databases
> @dbList=
>             "master,RPD",@r3Db="RPD",@bDev="R3DUMP0",@expDays= 27,@jobName=
> "SAP C
>             CMS Full DB Backup of master,RPD [20090620094326-6-094326]",
> @bkupCheck
>             sum="N",@bkupType="F",@nativeBkup="N",@exeDate = "20090620094326",
> @bku
>             pSim = "N",@format = 0,@init = 1,@bkupDb = "master",@unload = 0,
> @exeSt
>             mt = @exeStmt OUTPUT
> Status:     (failure)
> Message:    2528
> Severity:
> 16
> Duration:   0  hours(s)  0  min(s) 12 sec(s)
> Last msg:   Executed as user: NT AUTHORITY\SYSTEM. Access is denied due to a
> password failure [SQLSTATE 42000] (Error 3279)  BACKUP DATABASE is terminat
>             ing abnormally. [SQLSTATE 42000] (Error 3013)  DBCC execution
> complete
>             d. If DBCC printed error messages, contact your system
> administrator.
>             [SQLSTATE 01000] (Error 2528).  The step failed.
>                     <------------- End of Job Step History --------------->
>
> **************************** Job history information
> *****************************
>
>
> when i going to check the backup device by open the Media Contents (in SQL
> server 2005--> Right click on R3DUMP0) ) then generate the error message
> cannot open backup device 'R3DUMP0(\\.\tape0)', operating system error 2 (the
> system cannot find the file specified)
>
> Then please suggest me how can i access the tape0, for backup purpose from
> SQL SERVER 2005
>
> Thanks
> Jayesh
>
>

>Not a direct answer to your question, but a comment on the approach.
>
>It looks like you are trying to backup the databases straight to tape. The
>places where I worked have tried this with a varying degree of success. The
>primary motivation was to save the intermediate step of saving to disk first
>and therfore saving some storage space. In many cases, they eventually went
>back to back up databases to disk first because of reliability issues.
>
>Persoanlly, if I have a choice, I'd avoid backing up databases directly to
>tape.
>
>Linchi
>
>> Hello everybody,
>>    i have been suffer from problem that, I have installed the HP workstorage
>[quoted text clipped - 49 lines]
>> Thanks
>> Jayesh

"borasejay" wrote:

> Hi!
> Thanks for reply
>
> Because of database size is greater than 150 GB. that's why i am unable to
> take on
> HDD. so i want to take database backup on tape. I will scheduled at mid night
> means
> it also not impact on the performance.
>
> so please suggest me how to do?
> its so important for me
>
> Thanks
> Jayesh
>
> Linchi Shea wrote:
> >Not a direct answer to your question, but a comment on the approach.
> >
> >It looks like you are trying to backup the databases straight to tape. The
> >places where I worked have tried this with a varying degree of success. The
> >primary motivation was to save the intermediate step of saving to disk first
> >and therfore saving some storage space. In many cases, they eventually went
> >back to back up databases to disk first because of reliability issues.
> >
> >Persoanlly, if I have a choice, I'd avoid backing up databases directly to
> >tape.
> >
> >Linchi
> >
> >> Hello everybody,
> >>    i have been suffer from problem that, I have installed the HP workstorage
> >[quoted text clipped - 49 lines]
> >> Thanks
> >> Jayesh
>
>