|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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 jag Are 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? Show quoteHide quote "Ramuk" <Ra***@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 Show quoteHide quote "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 stand corrected -- 17 terabytes. Still not even close to 100.
"Alejandro Mesa" <AlejandroM***@discussions.microsoft.com> wrote in message http://www.microsoft.com/sql/techinfo/administration/2000/scalabilityfaq.aspnews:C85802E9-B841-49C5-A4A7-725B85145684@microsoft.com... > SQL Server Scalability FAQ > Show quoteHide quote > > > 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 Show quoteHide quote "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" <AlejandroM***@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 > > > 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. -- Show quoteHide quoteAndrew J. Kelly SQL MVP "Ramuk" <Ra***@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 Such as..? ;)news:ePN9TUWMFHA.436@TK2MSFTNGP09.phx.gbl... > > this on your own. I recommend you hire a "qualified" consultant to guide > you through this process. I could name a few but I won't<g>.
-- Show quoteHide quoteAndrew 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 > -- > >  
Other interesting topics
Primary File Group Full?
How to 'call' UDFs from SPs How to backup and restore related databases? SAN issues, please help could not find stored procdure xp_availablemedia TRXN LOG BKP time takes so much longer than Full BKP??? Data Migration Recommendations Needed Help needed with OpenQuery Backing up a database? Waitstats data within the Profiler Traces? |
|||||||||||||||||||||||
