Storing large data files in SQL Server

Tags:
SQL Server 2005
SQL Server 2008
SQL Server Data Storage
SQL Server Database Consolidation
What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Are you trying to store more than 2 Gigs of data in a single field of a single row, or are you trying to have a database larger than 2 Ggis?

If you are trying to store more than 2 Gigs of data in a single field of a single row you can’t. 2 Gigs is the limit. However you really shouldn’t be storing files that large in the database directly. You should store them on the file system directly and store a pointer to the fil ein the database.

If you are trying to have a database that is over 2 Gigs SQL Server will support databases into the several terabytes in size.

Only the Express edition is size limited and it is limited to 4 Gigs per database.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following