How to copy db from test server to local machine running MSSQL2000 Per.

[len]

I am in a situation where I need to get a copy of test database that is
on production server running MSSQL 2000 Standard to my local machine
running MSSQL 2000 personel. I tried to use the copy wizard where it
appears I get connected to the source server OK but when I try to
indicate the destination server which is my local machine I get errors
poping up about cannot connect to (local) etc.

I am NOT a DBA just a programmer trying to get a local test environment
up to be more productive.

Lsumnler

[angsql]

Re: How to copy db from test server to local machine running MSSQL2000 Per.

Hi,

go to the sql client network utility on sql 2000 standard and add the
IP address of the sql 2000 personal.
Try connecting first thru query Analyzer if it connects, then go try
sql wizard.

Easy way is to backup the DB on sql 2000 standard and restore on sql
2000 personal.

Let me know what happens

RA.

[Simon Hayes]

Re: How to copy db from test server to local machine running MSSQL2000 Per.


"len" <lsumnler@gmail .com> wrote in message
news:1113927630 .057592.236140@ o13g2000cwo.goo glegroups.com.. .[color=blue]
>I am in a situation where I need to get a copy of test database that is
> on production server running MSSQL 2000 Standard to my local machine
> running MSSQL 2000 personel. I tried to use the copy wizard where it
> appears I get connected to the source server OK but when I try to
> indicate the destination server which is my local machine I get errors
> poping up about cannot connect to (local) etc.
>
> I am NOT a DBA just a programmer trying to get a local test environment
> up to be more productive.
>
> Lsumnler
>[/color]

See this KB article - there are a number of requirements for the wizard to
work correctly:

http://support.microsoft.com/default.aspx?scid=kb;en-us;274463

If possible, you might find that backup/restore is an easier option:

http://support.microsoft.com/default.aspx?scid=kb;en-us;314546

Simon