Delete your "new" files. To create a copy of an existing database, follow
these steps:
1. Create a backup of your existing db.
2. Create a new database.
3. Choose to restore the newly created database. Use the original database's
backup set to restore with. Ensure that you alter the physical pathname of
the databse as you do the restore operation.
>-----Original Message-----
>From: Mark Derricutt [mailto:[EMAIL PROTECTED]]
>Sent: Monday, 26 June 2000 01: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
>
(This e-mail message and any accompanying attachments may contain
information that is confidential and subject to legal privilege. If you are
not the intended recipient, do not read, use, disseminate, distribute or
copy this message or attachments. If you have received this message in
error, please delete the message and, if convenient, inform the sender as
soon as possible.)
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
