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.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.
>
No comments:
Post a Comment