SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 07:07 AM
| ||||
| ||||
 How to copy db from test server to local machine running MSSQL2000 Per. 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      |
|
02-29-2008, 07:07 AM
| |||
| |||
| 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. |
|
02-29-2008, 07:08 AM
| ||||
| ||||
| 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.googlegr oups.com... >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 > See this KB article - there are a number of requirements for the wizard to work correctly: http://support.microsoft.com/default...b;en-us;274463 If possible, you might find that backup/restore is an easier option: http://support.microsoft.com/default...b;en-us;314546 Simon |
 |
« How to fetch or store a BIGINT using dbExpress and Delphi 2005
|
Using MSDE and moving databases »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 03:24 PM.
