Or you can use DTS, the GUI data pump that comes with SQL server.
> 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.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
