Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange SQL Server Behavior
Message
 
 
To
13/11/2007 07:24:02
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
OS:
Windows XP
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01268611
Message ID:
01268614
Views:
14
>SQL Server 2K MSDE has been running fine on this machine for a couple of years.
>I tried to add a 10 byte index to a 1.2 MM record table (200 bytes per record) and got "out of space on file group primary. To correct, add space"
>Never had this before.
>The DB's properties call for autmatically expanding the space.
>The DB is all corrupted now.
>Is there some kind of limit in MSDE or is this some kind of fluke?


Asking the obvious question, is there still space on the drive? If not that, check whether the database has a max size that has been hit.

Yes, MSDE has a limit. It is 2 GB per database.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform