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

backuk technic sql server 2000

Hello,
i have two questions :
1 - it's a better solution to save a database SQL with
log technic than a full save ' For a good restoration.
Without speak of all data restore possibility , just the
technic of restore.
2 - it's true that it's necessary to have the double disk
space to restore a full database ? Ex : 30 Go free space
to restore a database of 15 Go
Thanks for responseIt is depend what kind of restore possibility do you want.
If you will make only FULL BACKUP with Recovery Model Simple(SQL 2K) or
'Truncate Log on chk. point' checked(SQL 7)
you will not able to restore DB on any point of time. Aslo you will lose all
changes since last FULL BACKUP in case of DB corruption.
With Tr.Log BACKUP for example you will make FULL BACKUP once per some
period of time. Let say every night.
And then LOG BACKUP every let say hour.
So you will have the chain:
FULL BACKUP
LOG BACKUP
LOG NACKUP
LOG BACKUP
...
FULL BACKUP
In this scenario in case of DB corruption and if Log will corrupted too, you
will lose only data since last LOG BACKUP.
So, if you'll make LOG BACKUP hourly, maximun for one hour.
Regards
---
All information provided above AS IS.
"dtc" <anonymous@.discussions.microsoft.com> wrote in message
news:03fe01c39f18$6edb8ea0$a101280a@.phx.gbl...
> Hello,
> i have two questions :
> 1 - it's a better solution to save a database SQL with
> log technic than a full save ' For a good restoration.
> Without speak of all data restore possibility , just the
> technic of restore.
> 2 - it's true that it's necessary to have the double disk
> space to restore a full database ? Ex : 30 Go free space
> to restore a database of 15 Go
> Thanks for response