Can't connect to full MSDE 2000 (urgent)

I think I've "filled" an MSDE 2000 SP3a database to its maximum 2GB size, and now can't connect to it.

OSQL gets an "insufficient file size" error.

Have also tried to connect via Ent Mngr, and get database is "suspect" error.

How can I connect in order to purge some data?

Thanks!!!!

DT

When connecting using Enterprise Manager, which database is the suspect? Search for the database file in your file system (databasename_.MDF) and check whether you do have enough free space in the disk containing the MDF file. If not, try freeing up some space on that disk just for you to do maintenance. Then you can do a couple of things - truncate the log and shrink the file, move the database file to a different drive, extend the volume by adding disk, or free up some space by deleting large files on the disk.|||

We know which database, and there's plenty of room on the disk.

The problem isn't that we don't know how to make the database smaller... it's that we can no longer connect to it in order to truncate/shrink.

Can you recommend a recovery tool?

DT

|||

I was able to attach the database to a SQL2K instance, and do a backup.

Problem resolved