Thanks Martijn Tonies for replying so quickly.

I am aware that gbak can be use to handle this
situation. But is there any way to handle it through
SQL ? FYI, I am creating a utility to handle database
secondary file using Delphi 6.0 Profesional. Creating
a secondary file is ok but the problem here is how to
delete it through SQL ? By using SQL statement, I can
wrapped it under a function to delete the secondary
file.

btw Martijn Tonies, what do you mean by recycling
a file ? I tried to backup but couldn't backup the
database as the database is deleted via windows.

Yeap, I do agree too it is a bad idea to delete the
database via windows, but if this situation happens,
(might happen though because of "users"), any
solutions to get back the database ?

Thank you for helping.

Tan Chin Leong
Junior Database Administrator
Chrysanth Software Sdn Bhd.


--- Martijn Tonies <m.tonies@...> wrote:

> 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/
> >
> >
>
>

=====
Reply soon....

CLTAN from Malaysia...



__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com