Showing posts with label maximum. Show all posts
Showing posts with label maximum. Show all posts

Thursday, March 22, 2012

Database size

I would like to ask if 4 GB (maximum for SQL Server 2005 Express edition ) of database size means size of data file + log file size

Thanks

It is datafile size only.

http://technet.microsoft.com/en-us/library/ms345154.aspx - check Engine Specifications


HTH!

DataBase Size

People,
I have a database with 40 GB, and i wanna know the maximum size of a
DataBase in sql - server 2000...
thanks a lot...
--
----
Alexandre Santos
Softway - Sistemas
Tel: (48) 9101-1167 || (48) 251-8664
alexandre.santos@.softway.com.br
www.softway.com.br
----Alexandre,
1,048,516 TB
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Alexandre" <alexandre.santos@.softway.com.br> wrote in message
news:uvZE3R7dDHA.2524@.TK2MSFTNGP09.phx.gbl...
> People,
> I have a database with 40 GB, and i wanna know the maximum size of a
> DataBase in sql - server 2000...
> thanks a lot...
> --
> ----
> Alexandre Santos
> Softway - Sistemas
> Tel: (48) 9101-1167 || (48) 251-8664
> alexandre.santos@.softway.com.br
> www.softway.com.br
> ----
>
>

Sunday, March 11, 2012

Database Row Size Limit

Hi, All,

I came cross a problem like this.

Cannot create a row of size which is greater than the allowable maximum of 8060

Is there any method to solve this ?

This is by design, determined by data page size 8KB. Do you really need such a large row? You can put large columns like VARCHAR(8000) into TEXT columns.