Showing posts with label tapes. Show all posts
Showing posts with label tapes. Show all posts

Thursday, March 8, 2012

Backup calculation

I want to do a full backup every Sunday and Incremental
backup every day(i.e Mon -Sat) from Jan 2004 till Dec
2010.
The full backp up tapes have to be sent to safe and to
reuse the Incr Backup tapes. What i need to know is the
number of tapes needed and also any other things i have to
consider.
Is there anywhere i can get information about this or any
site to easily do these calculations? Thank you.I suggest you do your homework yourself instead of asking other people. It
is trivial.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Naz" <milnaz@.hotmail.com> wrote in message
news:0bcb01c3810b$9a9671c0$a401280a@.phx.gbl...
> I want to do a full backup every Sunday and Incremental
> backup every day(i.e Mon -Sat) from Jan 2004 till Dec
> 2010.
> The full backp up tapes have to be sent to safe and to
> reuse the Incr Backup tapes. What i need to know is the
> number of tapes needed and also any other things i have to
> consider.
> Is there anywhere i can get information about this or any
> site to easily do these calculations? Thank you.

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