Issue
Is there a limitation to the size the database can be on a Single User system in Continuum?
Product Line
Andover Continuum
Environment
- Single User Continuum system
- MSDE database
Cause
Microsoft has put a limitation in the size of the MSDE database. Once you hit this limitation your Single User Continuum system will not operate properly.
Resolution
The size limitation is 2 Gb.
It may be possible to recover after hitting this limit by removing un-needed log entries from the database, but this is not always a guarantee you will be able to recover the database.
Another way to recover from this is to back up the database, if you can, and restore it to standard SQL installation. From this point you can remove any unwanted logs and shrink the database. Then you can back up the database and restore it back to the Single User system.
Another way to recover from this is to back up the database, if you can, and restore it to standard SQL installation and convert the Single User system to a LAN installation.
Finally if all the above do not work for your system you will have to restore from the last known good backup of the database.
See Microsoft Database size Limitations and Continuum for SQL Express information.