Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Backup and restore solution for 800TB of data


Backup and restore solution for 800TB of data

Author
Message
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47241 Visits: 44377
Are you sure it's TB, not GB? A log file cannot be bigger than 2TB.


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17586 Visits: 32265
If this turns out to be gigs, I'm going to cry. I was terribly excited about an 800TB system.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Dwayne Dibley
Dwayne Dibley
Old Hand
Old Hand (382 reputation)Old Hand (382 reputation)Old Hand (382 reputation)Old Hand (382 reputation)Old Hand (382 reputation)Old Hand (382 reputation)Old Hand (382 reputation)Old Hand (382 reputation)

Group: General Forum Members
Points: 382 Visits: 3162
Grant Fritchey (4/29/2010)
If this turns out to be gigs, I'm going to cry. I was terribly excited about an 800TB system.


Me too.;-)
D.Oc
D.Oc
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1017 Visits: 6480
My bet is on GB's not TB.

-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."

GregoryF
GregoryF
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1014 Visits: 885
Aside from the fact that the largest size of a DB os 500TB, assuming you even had something that large.

How Many:
Teamed Network Cards?
HBA Controllers?
Drives (Max MDF file is on 16TB)

What server could handle 25 1GB network cards and 50 controller's?

How much total SAN space does the enterprise have? Few places have 1 PB of SAN Space just for data, let alone backups.

It could not be backed up over copper, fibre would still be very time consuming, even with the best router?

You could never DR it, the amount of time to logship/mirror multiple T3's would be very long...plus you would need that much space at the DR side.

I'm sure it's 800GB, but it's interesting to think of it it could be 800TB. However, I think given a max DB size of 500TB, he has to mean 800GB

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
Dugi
Dugi
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1316 Visits: 3511
If the situation is true, it would be very interesting about DB architecture info ( data files & log files architecture ) w00tHehew00t

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47241 Visits: 44377
GregoryF (4/29/2010)
Are you really sure it's 800TB and not 800GB?

SQL 2008 only support 512TB Databases
http://msdn.microsoft.com/en-us/library/ms143432.aspx

So does SQL 2005
http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx


No. Not 512 TB. 524,272 TB. 524 PB (petabytes)


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Dugi
Dugi
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1316 Visits: 3511
GregoryF (4/29/2010)
Are you really sure it's 800TB and not 800GB?

SQL 2008 only support 512TB Databases
http://msdn.microsoft.com/en-us/library/ms143432.aspx

So does SQL 2005
http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx


No SQL Server supports over 512 TB, take a look more closely, the MAX spec. is 524272 TB (that's means in Peta Bytes)! So if the situation is true, it can be ! w00t

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
GregoryF
GregoryF
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1014 Visits: 885
Dugi (4/29/2010)
GregoryF (4/29/2010)
Are you really sure it's 800TB and not 800GB?

SQL 2008 only support 512TB Databases
http://msdn.microsoft.com/en-us/library/ms143432.aspx

So does SQL 2005
http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx


No SQL Server supports over 512 TB, take a look more closely, the MAX spec. is 524272 TB (that's means in Peta Bytes)! So if the situation is true, it can be ! w00t


Thanks, I did not notice the factor of 100, I'm not used to files of such size...

But with a 16TB limit on datafiles, you would still need 50 datafiles. With a limit of 2TB on logs, 50 logs. That's an unrealistic number of drives with corresponding HBA cards. And both of those numbers assume that all files are at 100%.

The server that could process all of this, and the SAN that could store it, and the networking that can transfer it, would out of reach for all but the richest of companies.

If it's true, I'd love to play with it

/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
Bex
Bex
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1237 Visits: 1704
Steve Jones - Editor (4/29/2010)

Also, I'm curious how you are backing up the log every 10 sec. Are you using some external program. AFAIK, jobs to schedule can be done every minute, not more granular than that.



2008 can indeed go down to seconds, but I can't say I had noticed it before.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search