Storing large data files in SQL Server
What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 21, 2009 6:13 PM
UPDATED:
January 22, 2009 1:49 AM
RELATED QUESTIONS
- Is it possible to have a SQL Server stored procedure in Domain A read data from tables in Domain B?
- Stored procedures to script table data in SQL Server 2005
- SQL Server and MSMQ
- How can I write a stored procedure to copy data from one database to another database on the same SQL Server, every weekend?
- Looking for best approach to upgrade SQL Server 2000 databases to SQL Server 2005
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
