Anyone knows what is the max database size in MSDE, SQL 2000 and SQL 2005 ?From BOL
Maximum Capacity Specifications
Both SQL Server 2000 and 2005
Database Size 1,048,516 Terabytes
SQL Server 2000 MSDE
Database Size 2 GB
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:
> Anyone knows what is the max database size in MSDE, SQL 2000 and SQL 2005 ?
>
>|||This is a multi-part message in MIME format.
--010405010900060701050102
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
In addition to that, SQL Server 2005 Express Edition (which is the 2005
successor to MSDE) has a maximum DB size of 4GB (from
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx).
--
*mike hodgson*
http://sqlnerd.blogspot.com
Ben Nevarez wrote:
>From BOL
>Maximum Capacity Specifications
>Both SQL Server 2000 and 2005
>Database Size 1,048,516 Terabytes
>SQL Server 2000 MSDE
>Database Size 2 GB
>Ben Nevarez, MCDBA, OCP
>Database Administrator
>
>"Alan" wrote:
>
>>Anyone knows what is the max database size in MSDE, SQL 2000 and SQL 2005 ?
>>
>>
--010405010900060701050102
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>In addition to that, SQL Server 2005 Express Edition (which is the
2005 successor to MSDE) has a maximum DB size of 4GB (from
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx</a>).</tt><br>">http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx">http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx</a>).</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Ben Nevarez wrote:
<blockquote cite="mid1CE03E35-ACF5-4320-B704-7B0528159B35@.microsoft.com"
type="cite">
<pre wrap="">From BOL
Maximum Capacity Specifications
Both SQL Server 2000 and 2005
Database Size 1,048,516 Terabytes
SQL Server 2000 MSDE
Database Size 2 GB
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Anyone knows what is the max database size in MSDE, SQL 2000 and SQL 2005 ?
</pre>
</blockquote>
</blockquote>
</body>
</html>
--010405010900060701050102--|||Using SQL 2000 MSDE, I was able to restore a 30GB DB.
"Alan" wrote:
> Anyone knows what is the max database size in MSDE, SQL 2000 and SQL 2005 ?
>
>|||See the below URLS:
SQL 2005
http://www.yukonxml.com/Reference/default.aspx?t=Capacity
For SQL 2000 and older version see:-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
Thanks
Hari
SQL Server MVP
"SQL ADMIRER" <SQL ADMIRER@.discussions.microsoft.com> wrote in message
news:92DE7187-E52A-4DD2-BEC0-E1CA39F4EF05@.microsoft.com...
> Using SQL 2000 MSDE, I was able to restore a 30GB DB.
> "Alan" wrote:
>> Anyone knows what is the max database size in MSDE, SQL 2000 and SQL 2005
>> ?
>>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment