July 31, 2008 at 5:39 am
Hi,
i am using sql server express 2005, i am using multiple databases on it, i checked microsoft website and found that it has maximum database limit fo 1gb now what i am confused about is. does that mean
db1+db2+db3+ db4..=1GB
or each database can be of maximum 1gb size
please recommend
Thanx
ltoso
July 31, 2008 at 6:00 am
July 31, 2008 at 7:54 am
SQL Server Express can handle multiple databases each up to 4Gb in size (this excludes logfiles).
I think the 1Gb limit that you mentioned refers to the fact that SQL Server Express can only access 1Gb of server RAM.
July 31, 2008 at 8:32 pm
Hi,
yes i checked the database limit it is 4GB now what i am confused about is can i have multiple database in which each can expand to 4gb or all the database sizes added together shouldn't increase 4GB.
PLease recommend
Thanx ltoso
August 1, 2008 at 1:29 am
No one database in Express can be larger than 4 GB, but there is no limit on the number of databases you can use in Express.
From: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1082707,00.html
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply