August 4, 2008 at 6:30 pm
We will be getting transition from other team and have 400TB Datase , Can somebody point me to handle best practices for this much big DB and what should be the Backup strategies?
Thanks
August 4, 2008 at 9:18 pm
Take a look here: http://sqlcat.com/
I guess if you ask SQLCAT questions about 400TB database, they will be more than happy to help you.
August 4, 2008 at 10:04 pm
I'd second that and look to engage a consultant to review what is there. SQLCat can probably recommend someone.
August 5, 2008 at 9:18 am
My recommendation is to go for a Hyperbac Backup which is great. Compression rate is 75 to 80% and have lots of features like object recovery , means that you can recover object like stored procedure, views, table etc.
I am using it and pretty satisfied. Here is the link.
August 5, 2008 at 9:49 am
Are you really sure about the size of this database? Maybe it is really 400 GB?
400 TB would make it one of the world’s largest databases and I seriously doubt any organization with a database that size would be turning over management of it to someone who has to post questions about how to do backups on SQLServerCentral.
August 5, 2008 at 9:55 am
I thought i had a big databse at 1TB 🙂
400TB is huge, I can imagine that there would be plenty of issues invovled in maintaining it..
August 5, 2008 at 11:10 am
Some interesting points about recovering individual tables from backups using 3rd party tools here: http://www.sqlbackuprestore.com/recoveringindividualtables.htm
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
August 5, 2008 at 3:44 pm
Michael Valentine Jones (8/5/2008)
Are you really sure about the size of this database? Maybe it is really 400 GB?400 TB would make it one of the world’s largest databases and I seriously doubt any organization with a database that size would be turning over management of it to someone who has to post questions about how to do backups on SQLServerCentral.
tee hee hee 😀 you do have a point
with any large database you would use multiple disk arrays and filegroups for static tables and indexes. This would backup easier. What is you current database set up for this DB??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2008 at 7:18 am
Michael Valentine Jones (8/5/2008)
Are you really sure about the size of this database? Maybe it is really 400 GB?400 TB would make it one of the world’s largest databases and I seriously doubt any organization with a database that size would be turning over management of it to someone who has to post questions about how to do backups on SQLServerCentral.
Maybe it's 400TB because no-one has been running T-Log backups, they just added more disk space, the data could be just a few GB ?!?!? :hehe:
August 6, 2008 at 7:37 am
Maybe it's 400TB because no-one has been running T-Log backups, they just added more disk space, the data could be just a few GB ?!?!? :hehe:
😀 You made may day. 400TB and they are handling it over like "would you take care of my puppy while I go to the loo?" something is not right.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 6, 2008 at 8:27 am
To my knowledge 400TB would be far and away the largest SQL Server database in existence. I suspect that is a typo, but if it isn't, you will need upwards of 8 figures in hardware and software licensing (and consulting fees) to handle it and it's backups. And you have absolutely no hope of managing it if you are asking this question in the first place. Nothing personal there, btw, but even the best, brightest and most experienced SQL Server minds in the world would have to work HARD on a beast that big.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply