Re: moving server to a new box

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 12:16:55 -0400

Have a look here:

http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server 

-- 
Andrew J. Kelly  SQL MVP
"flologic" <flo@flo.net> wrote in message
news:Omrv91kdEHA.2504@TK2MSFTNGP12.phx.gbl...
> We are moving an older server to a new box. We will also change our
> disk/folder layout of all database files to distribute IO etc.. There are
> about 100 user databases with a lot of logins and jobs. I need your
opinion
> if my plan will work out.
>
> 1. Disconnect source server from network and stop all jobs
> 2. Detach all user databases
> 3. Full backup MSDB and Master databases
> 4. Attach all user databases to the new server
> 5. Restore master
> 6. Restore MSDB
>
> I have done detach and attach databases a lot of times, so I am fine on
> that. I am just not sure, if I restore master and MSDB, will all my logins
> (with server level permissions), linked servers and all my jobs (including
> maintenance plans) work? or is there any thing I need to watch?
>
> Thanks.
>
>

Relevant Pages

  • Re: object level permissions being lost when migrating
    ... I first transferred the logins from the 2000 server to the 2005 server via ... I then restored the databases and re-synched the users via the ... Errors After Restoring Dump ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... 2- Mixed Authentication (through SQL Server logins and Windows accounts) ...
    (microsoft.public.sqlserver.clients)
  • Re: Move databases between servers
    ... What I'm trying to do now is to copy master. ... Now I'm reinstalling sql with identical version, and restore all databases ... Since the logins are in master and operators/agents are in msdb why I ... copy all database and log files to new server ...
    (microsoft.public.sqlserver.setup)
  • Re: How to move system databases to new SAN drive in cluster serve
    ... I have moved model, msdb, and tempdb on a cluster ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.clustering)
  • Re: Migrate stand alone sql server to a cluster without downtime
    ... Use backup and restore to create the databases on the new system. ... Run a log backup WITH STANDBY on each database on the old server. ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
Loading