March 31, 2011 at 2:16 pm
Hi all,
We are replacing a physical server with another physical server which hosts a single default instance of SQL 2008 R2. All non-system DBs are on SAN space, so effectively-- I know I need to do the following general steps:
Transfer Logins and Passwords Between Instances of SQL Server with something like
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246133
export jobs, DTS, SSIS
run 'Select * FROM master.sys.master_files' to get a list of locations of all files for reference later
Stop SQL and set to disabled
detach 'user' DB volumes
rename server/remove from domain
Join new server to domain with old name
install SQL on new server
Attach 'user' volumes and DBs, attach DBs using path information from the query above
apply scripts generated from earlier (jobs/users/DTS/etc)
Any other suggestions/major steps I'm missing here? Thanks in advance. I just want other eyes to confirm I'm not missing something obvious.
March 31, 2011 at 2:33 pm
after renaming the Windows box be sure to run:
sp_dropserver 'OLD_SERVER_NAME'
sp_addserver 'NEW_SERVER_NAME', 'local'
then stop and restart service.
When we upgrade a productions server we rename and change the IP addresses. Shouldn't be necessary though unless who have some legacy stuff that requires a specific IP address.
The probability of survival is inversely proportional to the angle of arrival.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply