SQL Server Performance

Server re-build - need suggestions

Discussion in 'General DBA Questions' started by gkrishn, Oct 20, 2005.

  1. gkrishn New Member

    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.
  2. gkrishn New Member

    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
  3. Luis Martin Moderator

    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

    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.

  4. johnson_ef Member

    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.

  5. satya Moderator

  6. gkrishn New Member

    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:programfilesMSSQLDATA folder to my E: drive.

    4)uninstalled SQL server

    5)reinstalled SQL server.

    6)Droped current C:programfilesMSSQLDATA 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.


  7. satya Moderator

    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
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  8. gkrishn New Member

    Guru Approved <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />This activity is planned for next week. Anyone had done this before ?<br />-Rajiv
  9. gkrishn New Member

    Has anyone done this before ?
  10. satya Moderator

  11. gkrishn New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />Yes, I did that process, what doubts you have?<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />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 ?
  12. satya Moderator

Share This Page