Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
a_k_
Starting Member
23 Posts |
 Posted - 2004-10-07 : 13:12:51
|
| What is the maximum SQL Server database size? From which size we should consider to use Oracle? We need to store 7 Tb of image objects in database. Is it too much for one SQL Server database? Should we create several databases? Currently we have experience storing 800GB images in one SQL Server database.Thank you very much for your help,a_k_ |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-10-07 : 13:32:55
|
| I don' think there is a limit. There may be a prctical limit, but http://terraserver-usa.com/ is run on SQL Server 2000, and has 3.3 TB of data.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-07 : 14:06:01
|
| I believe Verizon Wireless has a database that is several terabytes. I think MS said it was over 10TB.Tara |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-10-07 : 15:03:05
|
| Isn't the consensus that storing images in SQL server isn't reccomended? I've always been told store a path to the images in SQL server, and store the images in the file system.that would allow you to separate you systems up a bit (SQL server, File server).Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
a_k_
Starting Member
23 Posts |
Posted - 2004-10-07 : 16:59:32
|
| If you store so many files in many subfolders, the access time may become a problem. Are there any may to store so large number of files efficiently? My experience is in Windows, probably in Unix it is not an issuer? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-07 : 17:01:30
|
| Storing them in the database will be even slower than on the file system.Tara |
|
|
|
|
|
|
Maximum SQL Server database size