locked
resource databae RRS feed

  • Question

  • Hi all,

    i red many articles Resource database makes upgrading to a new version of SQL Server an easier and faster procedure

    How the Resource database makes upgrading to a new version of SQL Server an easier and faster procedure..?

    please can you explain this question answer.


    how to rebuild resource database..?
    • Edited by SLNSH Friday, July 5, 2013 9:40 AM
    Friday, July 5, 2013 9:10 AM

Answers

  • Have a look at this link

    http://msdn.microsoft.com/en-us/library/ms190940.aspx

    The Resource database makes upgrading to a new version of SQL Server an easier and faster procedure. In earlier versions of SQL Server, upgrading required dropping and creating system objects. Because the Resource database file contains all system objects, an upgrade is now accomplished simply by copying the single Resource database file to the local server.


    Satheesh

    • Marked as answer by Fanny Liu Friday, July 12, 2013 3:03 PM
    Friday, July 5, 2013 9:17 AM
  • i red many articles Resource database makes upgrading to a new version of SQL Server an easier and faster procedure How the Resource database makes upgrading to a new version of SQL Server an easier and faster procedure..?

    >>Here you go-

     The Resource database makes it easy for service packs to be applied or rolled back whenever necessary. In case of  anSQL Server 2000, if you apply the service pack the system objects that exists on both system and user databases will also get  updates, so incase if you plan for the rollback it is very tough challenge but from SQL 2005+onwards the service pack changes & its updates to this database & that will reflected on all System &userdb, in case if you need to apply a service pack on all the instances then just you need to copy the MDF & LDF file in to safe locations so incase if you need to rollback you can just overwrite the files ,so that will make easy path interms easy & faster(but not truely).

    how to rebuild resource database..?

    >>This is always not necessary to rebuild but you need ensure that when ever you do administration part you need keep this file in safe path for ex-see

    Move System Databases
    http://msdn.microsoft.com/en-us/library/ms345408.aspx
    Look at the resoruce DB info-

    & you know alrady about Sp's/Hotfix

    Other info-

    The Resource Database
    http://sqlblog.com/blogs/kalen_delaney/archive/2007/09/13/geek-city-the-resource-database.aspx


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    • Marked as answer by Fanny Liu Friday, July 12, 2013 3:05 PM
    Saturday, July 6, 2013 11:19 AM

All replies

  • Have a look at this link

    http://msdn.microsoft.com/en-us/library/ms190940.aspx

    The Resource database makes upgrading to a new version of SQL Server an easier and faster procedure. In earlier versions of SQL Server, upgrading required dropping and creating system objects. Because the Resource database file contains all system objects, an upgrade is now accomplished simply by copying the single Resource database file to the local server.


    Satheesh

    • Marked as answer by Fanny Liu Friday, July 12, 2013 3:03 PM
    Friday, July 5, 2013 9:17 AM
  • how to rebuild resource database..?

    You don't. It's a hidden system databases, if you have an issue with it then you'll either need to re-install or copy a known good version over it (from a flat file backup).

    -Sean


    Sean Gallardy | Blog | Twitter

    Friday, July 5, 2013 12:33 PM
    Answerer
  • i red many articles Resource database makes upgrading to a new version of SQL Server an easier and faster procedure How the Resource database makes upgrading to a new version of SQL Server an easier and faster procedure..?

    >>Here you go-

     The Resource database makes it easy for service packs to be applied or rolled back whenever necessary. In case of  anSQL Server 2000, if you apply the service pack the system objects that exists on both system and user databases will also get  updates, so incase if you plan for the rollback it is very tough challenge but from SQL 2005+onwards the service pack changes & its updates to this database & that will reflected on all System &userdb, in case if you need to apply a service pack on all the instances then just you need to copy the MDF & LDF file in to safe locations so incase if you need to rollback you can just overwrite the files ,so that will make easy path interms easy & faster(but not truely).

    how to rebuild resource database..?

    >>This is always not necessary to rebuild but you need ensure that when ever you do administration part you need keep this file in safe path for ex-see

    Move System Databases
    http://msdn.microsoft.com/en-us/library/ms345408.aspx
    Look at the resoruce DB info-

    & you know alrady about Sp's/Hotfix

    Other info-

    The Resource Database
    http://sqlblog.com/blogs/kalen_delaney/archive/2007/09/13/geek-city-the-resource-database.aspx


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    • Marked as answer by Fanny Liu Friday, July 12, 2013 3:05 PM
    Saturday, July 6, 2013 11:19 AM