Friday, February 24, 2012

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.
>

No comments:

Post a Comment