sql msde database size limit

[edgare]

I had a few questins:

what happens if database exeeds 2 gigs on sql server 7 msde?
(is there a 2 gig limit on sql server 7 pe? and would msde upgrade to pe ? )

Is there a way to upgrade from sql 7 msde to sql server 2k developer? (on a 2k pro machine) After upgrade can the clients still connect or dev edition has limit on number of clients that can connect?

 

[mrdenny]

I believe that you will get errors that the database can't expand any further. I'm not really sure however.

You may be able to upgrade to Personal Edition.

You should be able to upgrade to developer edition with out a problem.

Dev edition has no limit on the number of users that can connect, however it is not licensed for production use.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[edgare]

It is actually a development enviroment ...
Another quick question does the "personal edition" of sql come bundled with std or ent? or is it separate cd??

 

[mrdenny]

Personal Edition comes with Enterprise Edition. It is not available as a seperate release.

If this is for development, why not use the development edition? It's on $50 direct from Microsoft and it's got all the features of Enterprise Edition but at a lower cost.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief