Discussion:
How much data can MSDE contain compared to SQL Server 2005 Express or 2008
(too old to reply)
Tony
2008-09-20 18:42:12 UTC
Permalink
Hi
How much data can MSDE contain compared to SQL Server Express 2005 or 2008

Kind regards.

Tony Thijs

Oriolus Publishing
Andrea Montanari
2008-09-21 10:40:14 UTC
Permalink
hi Tony,
Post by Tony
Hi
How much data can MSDE contain compared to SQL Server Express 2005 or 2008
MSDE is limited to 2gb data file(s) size per each database, where SQLExpress
2005 and 2008 are limited to 4gb..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply
Richard Stevens
2008-12-18 21:52:05 UTC
Permalink
Post by Andrea Montanari
hi Tony,
Post by Tony
Hi
How much data can MSDE contain compared to SQL Server Express 2005 or 2008
MSDE is limited to 2gb data file(s) size per each database, where
SQLExpress 2005 and 2008 are limited to 4gb..
How do using filestreams change the db size? Is it included?

--
Andrea Montanari
2008-12-19 10:49:38 UTC
Permalink
hi Richard,
Post by Richard Stevens
Post by Andrea Montanari
hi Tony,
Post by Tony
Hi
How much data can MSDE contain compared to SQL Server Express 2005 or 2008
MSDE is limited to 2gb data file(s) size per each database, where
SQLExpress 2005 and 2008 are limited to 4gb..
How do using filestreams change the db size? Is it included?
filestreams are not included and are not calculated in the limit size...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply
Loading...