Hi,

backup the database and restore it to a single file...

Deleting it via Windows is a _very_ bad idea. I don't know if you can
still create a backup - can you recycle the file?

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> Can someone help me on how to delete a secondary file using SQL ?
>
> As far as I am concerned, I have created a secondary file using
> SQL statement: ALTER DATABASE ADD FILE ...
>
> How to use SQL statement to delete a secondary file ? or is there a
> component to delete it ? I have tested IB Express Admin components
> but I couldn't remove the secondary file. :(
>
> btw, I did a test by deleting the secondary file purposely through
> normal file deletion (under Windows platform). After deletion,
> I can't connect to the main database anymore. The error that
> I got was the secondary file missing. Is there any way to make
> the main database valid/connectable ?
>
> Please help :)
>
> Thank you.
>
> Tan Chin Leong
> Junior Database Administrator
> Chrysanth Software Sdn Bhd.
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>