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.
Showing posts with label tapes. Show all posts
Showing posts with label tapes. Show all posts
Thursday, March 8, 2012
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.
>
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.
>
Subscribe to:
Posts (Atom)