Copying database between servers

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

  • Project 2003 EPM performance improvements
    ... Our upper management would like us to find out if there are any improvements ... The servers are midrange Dell ... The database server is using iSCSI technology for its SQL ...
    (microsoft.public.office.misc)
  • RE: Permissions
    ... servers are available to service the logon request. ... - Make certain that WINS database replication is successful between WINS ... Domainregistrations that are not listed in the ... If you are logged on as an administrator at a Domain Controller, ...
    (microsoft.public.win2000.security)
  • RE: Permissions
    ... >servers are available to service the logon request. ... >database does not have the proper domain registrations ... >If you are logged on as an administrator at a Domain ...
    (microsoft.public.win2000.security)
  • Re: Capacity Issues with SQL
    ... So go for 3 Servers. ... > We're running a bespoke CRM tool running SQL as its backend. ... > create too much extra storage, ... > processor to cover the database. ...
    (microsoft.public.windows.terminal_services)
  • Re: Best way to updat TNSNames.ora in all servers
    ... We have many unix servers running Oracle ... database 9.2.0 enterprise edition. ...
    (comp.databases.oracle.server)