SQL Server Performance Forum – Threads Archive

Server re-build – need suggestions

Hi ,
My clients had some issues with OS /applications due to some appli: upgrage and endedup with many issues.ALso Microsoft couldnt give a fix to that Hence they are planin to go for a server re-build. So my role would be 1)re-install SQL server 2)Bring back all the DBs. Can someone markout the steps involved ? Has anyone did similar project anytime?need all your suggestion on this.
-rajiv

1)anything i need to be taken care while re-installation?
2)how to bring back all my database with new installed SQLserver?
detach(old installation)/Attach(new installation) or Backup/restore

1) Backup all systems databases (execpt Microsoft suggest all new)
2) Backup you databases and dettach your databases (is a good idea to attach because is faster, but just in case…)
3) Install SQL, restore system databases, attach your databases.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

One suggestion is: Please try to take the login scripts and packages backup (if any ) this will help you if the restoration of master and msdb databases. Sometimes, master and msdb will give some problems, so better take these as backup. -Johnson

All useful KBAs and articles to read:
http://vyaskn.tripod.com/moving_sql_server.htm
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
http://vyaskn.tripod.com/troubleshooting_orphan_users.htm Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

I have one more idea ,which i tested in my local PC and it was a great SUCCESS .I have simulated my prod invironment in my local PC. here it goes … 1)i have created a test DB,test job,test login after a fresh installation of SQL server.
so now i have Master,Model,MSDB,TEMPDB,and TestDB . 2)i have shutdown the SQLserver. 3)copied C

rogramfilesMSSQLDATA folder to my E: drive. 4)uninstalled SQL server 5)reinstalled SQL server. 6)Droped current C

rogramfilesMSSQLDATA and bring it back same from E: drive. 7)started SQL server. I was surprised to see all my DBs a)Master,Model,MSDB,TEMPDB,and TestDB ]
b)Test Job
c)Test LOgin workin fine . Is this a recommended procedure? Has anyone ever did an R&D on this? Let me knwo your thoughts. -Rajiv

When you reattch or rebuild master with new settings SQL server will take new settings and your approach seems ok to me and it works. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Guru Approved <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> This activity is planned for next week. Anyone had done this before ? -Rajiv

Has anyone done this before ?

Yes, I did that process, what doubts you have? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by satya Yes, I did that process, what doubts you have? <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center> <hr height="1" noshade id="quote"></blockquote id="quote"> That again raised my confidence <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> .But i have not seen this documented anywhere or discussed in any forums.So i was just wondering is that somthing i discovered <img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ /> .Is this recomended by M.S ?

That is what I referred:
All useful KBAs and articles to read:
http://vyaskn.tripod.com/moving_sql_server.htm
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
http://vyaskn.tripod.com/troubleshooting_orphan_users.htm
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>