Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 30th, 2007, 02:55 AM
Authorized User
 
Join Date: Oct 2006
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database Storage Capacity

I was wondering what is the Database Storage Capacity for the following databases:

MySQL 5

Microsoft Sql Server 2005

MS Access 2003



Thanx

-----------------------------------------------
www.chargertek.in - Cheapest WebHosting
__________________
-----------------------------------------------
www.chargertek.in - Cheapest WebHosting
 
Old January 30th, 2007, 09:36 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

Access has a limit of 2GB.

MySQL I do not know exactly. If you are running a Win OS and are using the NTFS format, then your table sizes can't excceed 2TB but as far as a maximum database size i am not sure.

MS SQL has a limit of 32TB for Data and Log files.

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
 
Old December 22nd, 2008, 02:55 AM
Authorized User
 
Join Date: Oct 2006
Posts: 60
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by dparsons View Post

MS SQL has a limit of 32TB for Data and Log files.

Sorry for digging this old thread, but the MS site shows that the DBs are limit less

http://www.microsoft.com/Sqlserver/2...-features.aspx


Plz confirm on this.

Thanx
__________________
-----------------------------------------------
www.chargertek.in - Cheapest WebHosting





Similar Threads
Thread Thread Starter Forum Replies Last Post
Password encryption and storage in the database. zaheerabbas.sk ASP.NET 1.0 and 1.1 Basics 4 July 30th, 2008 05:03 AM
intermediate storage sarah lee ASP.NET 1.0 and 1.1 Basics 3 September 11th, 2006 01:31 PM
date storage simplyAns Oracle 4 October 20th, 2004 03:59 AM
capacity of SQL Server 7.0 trangd Beginning PHP 1 January 30th, 2004 04:45 PM
Document Storage [email protected] SQL Server 2000 1 December 23rd, 2003 10:36 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.