Document Management. Where to Store Documents. In file System or Database.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Document Management. Where to Store...

Document Management. Where to Store Documents. In file System or Database.

Rate Topic

Display Mode

Topic Options

Author

Message

anil.rajendran

Posted Monday, May 10, 2010 1:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 12, 2010 6:47 AM
Points: 2, Visits: 8

Hi Everybody

We are in design of a Document Management System. The application is expected to store files of type Office Documents, Images and PDFs and the count of documents would be between 2000 and 3000 per day. I would like to know primarily where the documents to be stored; i.e Store the files in File System or to Store in Database.

If I store the files in Database will the database be able to hold the load.

Experts Please Advise.

Thank You.

Anil

Post #918841

GilaMonster

Posted Monday, May 10, 2010 2:17 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 37,732, Visits: 29,996

Since you're using SQL 2008, have you considered FileStream? Best of both worlds - in the filesystem, backed up with the database.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #918858

anil.rajendran

Posted Monday, May 10, 2010 3:54 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 12, 2010 6:47 AM
Points: 2, Visits: 8

I Haven't. I am new to Filestream. I will go through that. Thank you very much for you insights on that.

Post #918886

« Prev Topic | Next Topic »

Permissions