Aren't you supposed to dump the database and then restore it? Seams to be
the way I recall doing it in 6.5.
Of course, I could say "get Interbase", but that wouldn't be being objective
:)
N
--
Nic Wise - [EMAIL PROTECTED] / Inprise/Borland New Zealand
ddi: 09.360.6713 / cell: 021.676.418
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Derricutt
> Sent: Monday, 26 June 2000 13:31
> To: Multiple recipients of list database
> Subject: [DUG-DB]: i broke sql7 :( help :)
>
>
> Hiya, I've kinda broken my sql7 database and wondered if anyone had any
> ideas on what I could do...
>
> I wanted to duplicate my database so I could have two copies, so I
> shutdown the server, copyied the files to a new name (new_sfman.mdf and
> new_sfman_log.sdf) and then restarted the server... initially the new db
> was listed in the enterprise manager, only now... this is what I get...
>
> When I run EM, if I open the Databases node I get "(no items)", hitting F5
> to refresh lists shows all the databases, only the original AND copied db
> now have "(suspect)" written after them, and both failing to open and
> listing "(no items") under them.
>
> Surely just copying the files wouldn't corrupt the db? I could understand
> the new one not working, but not the old one. Anyone hve any ideas?
>
> --
> Inspired by the taste of horror, proud to be insane forever
> Let out the killer in me! (c) Dismal Euphony
> Now Playing: <no audio cd present>
>
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
