transfering database contents

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "JRL" <jrl@xxxxxxxxxxxxx>
Date: Sat, 14 Mar 2009 16:52:43 -0700

Using sqlexpress, how do I move my membership database from one server to the development server? The two servers are on the same intranet.

Here's what I tried:

Backup database from production server, then on development server tried to restore the backup. No can do: since it sees the backup is from another server.

On development server, tried to import from the production server. But it can't seem to connect, even though named pipes are enabled on both servers, and I am using the same account name on both servers.

What do you recommend as a proceedure to get the date transferred?

.

Follow-Ups:
- RE: transfering database contents
  - From: Mark Han[MSFT]

Prev by Date: Re: 2 media families for backup
Next by Date: Sample databases for SQL Server 2005 and SQL Server 2008
Previous by thread: SQL Server 2008 Developer Edition Install Failed
Next by thread: RE: transfering database contents
Index(es):
- Date
- Thread

Relevant Pages

Re: Subversion web development question.
... Currently we're using ASP on Win2K with SQL Server 2000. ... I have found information on how to update files on the live server from the development server, but not much in the way of how to set up a development server to get Subversion to update the files in the Apache directories. ...
(freebsd-questions)
Re: Subversion web development question.
... Currently we're using ASP on Win2K with SQL Server 2000. ... The parameters to access these files are hard to duplicate to a workstation, and it has proved to be easier to test these apps on a server that is a mirrored environment of the live server. ... I have found information on how to update files on the live server from the development server, but not much in the way of how to set up a development server to get Subversion to update the files in the Apache directories. ...
(freebsd-questions)
Re: Poor performance under IIS
... 2008 web server) it takes 2 seconds. ... How isolated is your application in the IIS Server? ... In the ASP.NET Development Server, your app can use up to 100% of the CPU time. ...
(microsoft.public.dotnet.framework.aspnet)
SUMMARY: Perl module installs on one server, fails on another...
... production server (I guess I have to admit that I'm not as young as I used ... > the Perl module in question. ... > There is a Perl module which I have downloaded from ... > without a problem on the development server. ...
(SunManagers)
Perl module installs on one Sun server, fails on another...
... must be something related to my system setup and not Perl or the Perl ... I successfully installed the module on our development server, ... Perl module on our production server, an E4500 also running Solaris 2.8 ...
(SunManagers)