Re: Upgrading Hardware, how best to move?

From: Vinodk (vinodk_sct@hotmail.com)
Date: 03/27/03 

From: "Vinodk" <vinodk_sct@hotmail.com>
Date: Thu, 27 Mar 2003 15:11:30 +0530

Here are few Articles for reference

MovingDB's between Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546

Q246133 INF: How To Transfer Logins and Passwords Between SQL Servers
Q298897 Mapping Logins & SIDs after a Restore
Q240872 How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
Q224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach 

-- 
HTH,
Vinod Kumar
MCSE, DBA, MCAD
SCT Software Solutions 
 
"Ron Weldy" <ronweldy@msn.com> wrote in message news:Oxz5$ZD9CHA.2284@TK2MSFTNGP12.phx.gbl...
> I am upgrading my SQL box to a new machine and have been experimenting with
> backup and restore to move my databases. This method does not seem to bring
> over all the users and security settings. Is there a way to script or
> otherwise move all the settings and preserve them? Do I have to backup and
> restore the master database?
> 
>

Relevant Pages