Groups > comp.databases.ms-sqlserver > #681

Re: BLOB storage options

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.server
Subject	Re: BLOB storage options
Date	2011-09-27 22:56 +0200
Organization	Erland Sommarskog
Message-ID	<Xns9F6DE9717B25BYazorman@127.0.0.1> (permalink)
References	<3ac80097-f67b-4e86-9062-a1cb4a51b80a@m37g2000yqc.googlegroups.com> <Xns9F6CDD526413FYazorman@127.0.0.1> <d879a6b7-c547-483e-bf63-619c1823c4b2@n15g2000vbn.googlegroups.com>

Cross-posted to 2 groups.

Show all headers | View raw

Bill E. Hollywood, FL (behrreich@compuserve.com) writes:
> I'm not sure how large the database will be for just data, but I am
> expecting three or four thousand document uploads per month once
> things get going.  Therefore, the file storage and retrieval component
> will not be trivial.  It's hard to say how large the documents might
> be because they could be in many formats.  Let's assume an average of
> 500 kB per document and about 4,000 documents per month -- that gives
> us 2GB per month of just document storage.

500 kB appears a tad high to me, but that is just gut feeling.

But even if we accept this number - after three years the database 
will be 72 GB - provided that documents are kept "forever" and not
archived anywere.

To be honest, I am not sure that this warrants a more complex solution
to make it easier to have a development database, unless are other reasons 
you want a document-less database for development. True, restoring
72 GB takes longer time than restoring 1GB, but it's not an operation
I expect you do very often.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

BLOB storage options "Bill E. Hollywood, FL" <behrreich@compuserve.com> - 2011-09-26 04:14 -0700
  Re: BLOB storage options Erland Sommarskog <esquel@sommarskog.se> - 2011-09-26 21:45 +0200
    Re: BLOB storage options "Bill E. Hollywood, FL" <behrreich@compuserve.com> - 2011-09-27 07:50 -0700
      Re: BLOB storage options Erland Sommarskog <esquel@sommarskog.se> - 2011-09-27 22:56 +0200
        Re: BLOB storage options "Bill E. Hollywood, FL" <behrreich@compuserve.com> - 2011-09-27 15:01 -0700

csiph-web