Managing TB size of data

hi,
I jsut want ot know what are the challenges we should face in managing few
100 TB size large DB. What is the best way to do the backup and in the live
24 * 7 environment how to do the Full backup if needed?
SOS.
thanks
jagAre you sure you mean terabytes, as in 1000 gigabytes? I haven't heard of
any SQL Server database over 8 TB -- so I doubt anyone knows what the
challenges are with something as large as you're describing. What industry
is this for? And what kind of disk system do you have in mind to support
it?
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Ramuk" <Ramuk@.discussions.microsoft.com> wrote in message
news:07FE34A4-DB6C-4BD0-9912-5F6A1F2FE0E0@.microsoft.com...
> hi,
> I jsut want ot know what are the challenges we should face in managing few
> 100 TB size large DB. What is the best way to do the backup and in the
live
> 24 * 7 environment how to do the Full backup if needed?
> SOS.
> thanks
> jag|||SQL Server Scalability FAQ
http://www.microsoft.com/sql/techinfo/administration/2000/scalabilityfaq.asp
AMB
"Ramuk" wrote:
> hi,
> I jsut want ot know what are the challenges we should face in managing few
> 100 TB size large DB. What is the best way to do the backup and in the live
> 24 * 7 environment how to do the Full backup if needed?
> SOS.
> thanks
> jag|||If you are really talking about 100TB then there is no way you can get a
detailed enough answer on a newsgroup for such a general question. A DB
that size must be properly planed and if you are asking these type questions
you simply do not have the necessary background to accomplish a task like
this on your own. I recommend you hire a "qualified" consultant to guide
you through this process.
--
Andrew J. Kelly SQL MVP
"Ramuk" <Ramuk@.discussions.microsoft.com> wrote in message
news:07FE34A4-DB6C-4BD0-9912-5F6A1F2FE0E0@.microsoft.com...
> hi,
> I jsut want ot know what are the challenges we should face in managing few
> 100 TB size large DB. What is the best way to do the backup and in the
> live
> 24 * 7 environment how to do the Full backup if needed?
> SOS.
> thanks
> jag|||"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:ePN9TUWMFHA.436@.TK2MSFTNGP09.phx.gbl...
> this on your own. I recommend you hire a "qualified" consultant to guide
> you through this process.
Such as..? ;)
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--|||I stand corrected -- 17 terabytes. Still not even close to 100.
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:C85802E9-B841-49C5-A4A7-725B85145684@.microsoft.com...
> SQL Server Scalability FAQ
>
http://www.microsoft.com/sql/techinfo/administration/2000/scalabilityfaq.asp
>
> AMB
> "Ramuk" wrote:
> > hi,
> >
> > I jsut want ot know what are the challenges we should face in managing
few
> > 100 TB size large DB. What is the best way to do the backup and in the
live
> > 24 * 7 environment how to do the Full backup if needed?
> >
> > SOS.
> >
> > thanks
> > jag|||Adam,
You were right, 17 tb for the group of dbs.
AMB
"Adam Machanic" wrote:
> I stand corrected -- 17 terabytes. Still not even close to 100.
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
> news:C85802E9-B841-49C5-A4A7-725B85145684@.microsoft.com...
> > SQL Server Scalability FAQ
> >
> http://www.microsoft.com/sql/techinfo/administration/2000/scalabilityfaq.asp
> >
> >
> > AMB
> >
> > "Ramuk" wrote:
> >
> > > hi,
> > >
> > > I jsut want ot know what are the challenges we should face in managing
> few
> > > 100 TB size large DB. What is the best way to do the backup and in the
> live
> > > 24 * 7 environment how to do the Full backup if needed?
> > >
> > > SOS.
> > >
> > > thanks
> > > jag
>
>|||I could name a few but I won't<g>.
--
Andrew J. Kelly SQL MVP
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:%23MY2ydWMFHA.1096@.tk2msftngp13.phx.gbl...
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:ePN9TUWMFHA.436@.TK2MSFTNGP09.phx.gbl...
>> this on your own. I recommend you hire a "qualified" consultant to guide
>> you through this process.
> Such as..? ;)
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>