Re: Copying database between servers

I've used Enterprise Manager to export the original database and import it
to the new server. As I recall, I got an error popup and was given the
opportunity to change the location.

One approach I've used is to create the directory structure I wanted on the
new server. I then detached the database (in Enterprise Manager) and copied
the MDF file to where I want it. Then attach the database and change the
location of the MDF file. Verify it works and delete the old copy. You can
do the same for the LDF (log) file...

--
Regards,
Hank Arnold

"Bigalexx" <Bigalexx@xxxxxxxxxxxxxxxx> wrote in message
news:%23sv3s3HBGHA.2040@xxxxxxxxxxxxxxxxxxxxxxx
>I need to move a SQL 2005 database between 2 servers.
> But the 2 servers have different path structure due to language
> difference. One server has the databse installed under "c:\Program Files
> ..." and the other under "C:\Programmer..." It is not possible to restore
> the database, and present the error Directory lookup for the file"
> C:\Programmer\Microsoft SQL Server\MSSQL\Data\xx_Data.MDF" failed with the
> operating system error The path was not fould.
>
> How can I manually manage the backup and Restore to accomodate the
> different path setup on the 2 servers?
>


.

Relevant Pages

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: major security concern - any sql user with minimal permission can see code for all stored procs
    ... this you may well enter the realm of an unsupported configuration and that's ... > things - and hence has enterprise manager - then this approach won't work. ... > If you just want to lock down a database, then I'd try my approace - lock ... >>> who needed to execute an SP on my server at his location. ...
    (microsoft.public.sqlserver.security)
  • Re: restore master and not working the enterprise manager**
    ... Enterprise Manager is different from what's stored in the backup. ... I suggest you go to command prompt, and login to SQL Server using the same ... specify the default database as master). ... restored now) was taken, then you will have to restore or attach those ...
    (microsoft.public.sqlserver.server)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)