Re: Login

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ed (Ed_at_discussions.microsoft.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 09:25:05 -0700

Richard,
  Do you also have any idea about how to restore the Master Database?
What I am planning to do is
1. Backup (Old Server) all the databases (User and System) to a share folder
2. Create each individual user database in New Server
3. Restore each user database and retrive the backup files from the share
folder
4. Restore MSDB, MODEL database
5. Use DTS to transfer all the server log-in to New Server

is there anything wrong on doing this? How about dealing with the Master
Database, it needs to be transfered, too.......

Thank you very much
Ed

"Richard Ding" wrote:

> The way I do when migrate server is to install the SQL server first. then
> use sp_help_revlogin to create all logins on the new server. Next start
> restoring user databases as well as msdb.
>
>
> "Ed" <Ed@discussions.microsoft.com> wrote in message
> news:C385D215-78F3-41BF-92BB-6F5431A1BC44@microsoft.com...
> > Richard,
> > So if i do a server migration, I need to take care of the Server Log-in
> > first or User databases Log-in first or doesn't matter...
> > Thanks again
> > Ed
> >
> > "Richard Ding" wrote:
> >
> > > No that is not correct.
> > >
> > > Server logins are kept in master.dbo.sysxlogins table, or better yet,
> > > syslogins view.
> > > Each database keeps their own user accounts in sysusers table.
> > >
> > > When you move to a new server, you may encounter orphaned users when
> > > restoring databases because the new server SID does not match the source
> > > SID. You can use sp_change_users_login to resync the SID, or use
> > > sp_help_revlogin to script out all logins with their original SIDs and
> run
> > > it to create logins on the new server.
> > >
> > >
> > >
> > >
> > > "Ed" <Ed@discussions.microsoft.com> wrote in message
> > > news:0FA72DC1-AF86-422E-96CA-FCB183B4FE66@microsoft.com...
> > > > Hi,
> > > > I am under the impression that the master database contains all
> log-in
> > > > info for each database, is that correct?
> > > > How about the server log-in? If i need to do the server migration,
> i
> > > need
> > > > to transfer all the server log-in manually (or using DTS Transfer
> log-in
> > > task)
> > > > is that true?
> > > > Thanks a lot
> > > > Ed
> > >
> > >
> > >
>
>
>

Relevant Pages

  • Re: Problem with disable msde connection pool
    ... 'ALTER DATABASE TestDB SET single_user WITH ROLLBACK after 10 ... ' Restart the server... ... ' Execute query through SQLDMO to run the restore TSQL command ... the connection pool must be disabled. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Restore public folders and companyweb
    ... I understand that the Public Folder Store ... > database cannot be mounted due to integrity problems, ... > the pub.edb database from your backup of the old Server, ... please try the following steps to restore your public ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • RE: How to restore edb & stm files from bkf backup file on another exc
    ... copied to a different storage group on the same server or to a different ... On production server successfully backup information ... Restore Status ... Failed to find a database to restore to from the Microsoft ...
    (microsoft.public.exchange.admin)
  • RE: Restore public folders and companyweb
    ... The new server must have the same domain name as the original server ... where the backup of the database. ... For the detailed steps to restore the SharePoint Services databases, ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)