Re: SQL DATABASE TRANSFER

Dale E. Reed Jr. ( (no email) )
Fri, 06 Jun 1997 10:37:12 -0700

Warren Kipp wrote:
>
> Hello,
>
> I have just installed a new SQL server. I wish to now transfer all
> the
> necessary emerald database files from my older (working) SQL server to
> the
> new one. In my SQL Enterprise manager I can see both servers, and I'm
> wondering is therer an easy way to do this?
>
> Any light on this matter would be appreciated.
>
> PS. We are moving the SQL server to its own box to spread the network
> load.

1st, You need to create the database to receive the transfer on the
new box. Easiest way to do this, if you are savvy in SEM, is to use
the Emerlad admin to install an Emerald database on the new box.

Right-Click over the current Emerald database, and on the bottom
is transfer. Select it.

For the destination, choose your new box and the database you created
above.

Let it fly and double check when done.

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com