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

Susan Harkins ssharkins at setel.com
Sun Aug 27 09:49:51 CDT 2006


John... Right-click the service, choose Properties and view the Edit Server
Registration Properties -- might get a clue there. 

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".




More information about the dba-SQLServer mailing list