Backup a DB to different tapes in SQL Server 2000

Hello,
I know That it is possible to backup a DB to different
tapes because tape storage capacity is not enough to save
that DB. Which T-SQL command is used ?
Thank you.You simply start the backup to tape... when the tape is full, you will get a
console message asking you to mount another tape and respond. The response
message will be in the console message that SQL Sends to you.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Belma Canik" <bcanik@.fintek.com.tr> wrote in message
news:08bd01c371f2$4014dfc0$a301280a@.phx.gbl...
> Hello,
> I know That it is possible to backup a DB to different
> tapes because tape storage capacity is not enough to save
> that DB. Which T-SQL command is used ?
> Thank you.
>

BACKUP - BCV

HI,
I am working with a DW and my costumer hired a service in
a colocation and we're using a STORAGE to store all data !
and he also contract a backup system called BCV that
connects to the storage that I'm using and then copy all
the information, but during this process he blocks all the
activity in the disk and syncronyze the information and
after that he releases the disk. I would like to know if
someone heard about it our work with it..
Thank's
Roberto CarrascoYes we use it. We use EMC and what basically happens is that it Freezes
your SQL Server IO and then thaws it. You will see this in the logs. We
use it on most of our systems and the process takes ~ 5 seconds. We have no
problems with it. it does not appear to affect replication or anything
(touch wood)
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Roberto Carrasco" <roberto_carrasco@.msn.com> wrote in message
news:09e201c37215$bfa001c0$a501280a@.phx.gbl...
> HI,
> I am working with a DW and my costumer hired a service in
> a colocation and we're using a STORAGE to store all data !
> and he also contract a backup system called BCV that
> connects to the storage that I'm using and then copy all
> the information, but during this process he blocks all the
> activity in the disk and syncronyze the information and
> after that he releases the disk. I would like to know if
> someone heard about it our work with it..
> Thank's
> Roberto Carrasco
>|||Nope you don't stop anything. The BCV/Symmetrix software handles
everything.
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Roberto Carrasco" <Roberto_carrasco@.msn.com> wrote in message
news:120f01c37255$06d513c0$a401280a@.phx.gbl...
> Hi,
> Thank's for your reply ! Is necessary to stop the SQL
> SERVICE - Do I need to do something ' If I need to
> restore ! Do I have to STOP SQL SERVER SERVICE .
> Please ANswer
> Thank's
> Roberto Carrasco
> >--Original Message--
> >Yes we use it. We use EMC and what basically happens is
> that it Freezes
> >your SQL Server IO and then thaws it. You will see this
> in the logs. We
> >use it on most of our systems and the process takes ~ 5
> seconds. We have no
> >problems with it. it does not appear to affect
> replication or anything
> >(touch wood)
> >
> >
> >
> >--
> >
> >--
> >Allan Mitchell (Microsoft SQL Server MVP)
> >MCSE,MCDBA
> >www.SQLDTS.com
> >I support PASS - the definitive, global community
> >for SQL Server professionals - http://www.sqlpass.org
> >
> >
> >
> >"Roberto Carrasco" <roberto_carrasco@.msn.com> wrote in
> message
> >news:09e201c37215$bfa001c0$a501280a@.phx.gbl...
> >> HI,
> >> I am working with a DW and my costumer hired a service
> in
> >> a colocation and we're using a STORAGE to store all
> data !
> >> and he also contract a backup system called BCV that
> >> connects to the storage that I'm using and then copy all
> >> the information, but during this process he blocks all
> the
> >> activity in the disk and syncronyze the information and
> >> after that he releases the disk. I would like to know if
> >> someone heard about it our work with it..
> >>
> >> Thank's
> >>
> >> Roberto Carrasco
> >>
> >
> >
> >.
> >