[dba-SQLServer] Transferring a database to another SQL Server

So, are you trying to make a remote connection ?

Susan H. 


I'm not sure about the login issue, but a good way to transfer the DB is to
Detach it on the old server, copy the MDF and LDF files to the new server
and then attach it.  This will preserve all of the data, and has worked for
me several times.

On 8/27/06, JWColby <jwcolby at colbyconsulting.com> wrote:
> I have just finished rebuilding a machine (new motherboard) and need 
> to transfer a large SQL Server database to that new server.  The two 
> servers can see each other (shared folders), but ...
>
> I cannot register the other SQL Servers, getting an error "Login 
> failed for 'MachineName\Guest'.  I get this error on either machine 
> when trying to register the SQL Server on the other machine.  My login 
> user / password is the same on both machines.  Both databases were 
> installed using "Windows Authentication" rather than "SQL Server
Authentication".