MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

SQL Server

  Asked By: Jean    Date: Feb 28    Category: MOSS    Views: 819

I want to know if sql Server can handle ten terabytes of data or is Oracle
better for that.I understand that this might not be the ideal forum to ask this
question but i am sharepoint guy and i have to give an answer to this question.



6 Answers Found

Answer #1    Answered By: Lynette Sawyer     Answered On: Feb 28

The first thing that comes to mind is that you don't have the option to
use Oracle with SharePoint. You have to use SQL server. And if you're
just getting asked the question  from another group because you admin
SharePoint, that's ridiculous. You can't use Oracle with SharePoint, so
I don't see the connection at all.

I think SQL can handle  10 terabytes fine. You may have to use multiple
DBs, partitions, file groups, stuff like that, but I think it would work

Answer #2    Answered By: Joanne Greer     Answered On: Feb 28

You have no choice other than to use sql

Sql can handle  10tb of data

I have worked on 5tb data  sets on das

Depending on how many databases you can splitYour moss implementation down to
you may be able to use das but I suspect you'll need a san

Its the i/o that will most likely be the deciding factor

Answer #3    Answered By: Vinay Thakur     Answered On: Feb 28

Microsoft IT and other customers have SharePoint installations with more
than 10 TB of SharePoint storage.

Oracle isn't an answer  as SharePoint only supports SQL Server.

Answer #4    Answered By: Kerri Steele     Answered On: Feb 28

I have implemented 55TB + on a MOSS farm. As they have said, you
may require a 2nd SQL instance, but not necessarily. 10TB is not very
much data  anymore...

Remember that 2TB is the maximum database size you can failover using
SQL clustering, so not until ~46TB, you would absolutely require a 2nd
SQL instance. Most likely, performance will have been an issue prior to
that limit of SQL clustering. The limitation in your design will not be
SQL per se, but the hardware that is supporting it. A 10TB MOSS
installation can greatly benefit from a well designed/implemented Fibre
channel SAN back-end.

Answer #5    Answered By: Alisha Itagi     Answered On: Feb 28

Does Microsoft have a support method for backup / restore or disaster
recover that volume of sharepoint  data?

I'm guessing that in this implementation a SAN with some sort of
snapping or mirroring was used.

Answer #6    Answered By: Octavio Dotson     Answered On: Feb 28

Yes, this will require SAN snapshots, imho. I wouldn't be comfortable
restoring large amounts of data  from any tape system in a reasonable
amount of time.

Didn't find what you were looking for? Find more on SQL Server Or get search suggestion and latest updates.