locked
update the sql server from resource database RRS feed

  • Question

  • How to update the sql server from resource database...?
    Monday, August 9, 2010 7:31 AM

Answers

  • The Resource database should only be modified by or at the direction of a Microsoft Customer Support Services (CSS) specialist. The only supported user action is to move the Resource database. 

    To know when the Resource Database last updated just run the query;

    SELECT SERVERPROPERTY('ResourceLastUpdateDateTime');
    GO													
    
    

    The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does not contain user data or user metadata.

    Source: SQL Server BOL


    Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!
    • Proposed as answer by Tom Li - MSFT Tuesday, August 10, 2010 10:43 AM
    • Marked as answer by Tom Li - MSFT Tuesday, August 17, 2010 1:18 PM
    Monday, August 9, 2010 9:42 AM

All replies

  • What exactly you want to perform?
    SKG: Please Marked as Answered, if it resolves your issue.
    Monday, August 9, 2010 7:44 AM
  • Hi,

     Resource database is hidden database introduced from SQL Server 2005.. It is not dorectly accessible ... Please let us know your actual requirement ..

    -- Reddy Balaji C.

    Monday, August 9, 2010 9:04 AM
  • Thanks,

    I want to see step by step that how resource database is helpful to upgrade the sql server step by step...as it has written everywhere...

    Monday, August 9, 2010 9:26 AM
  • The Resource database should only be modified by or at the direction of a Microsoft Customer Support Services (CSS) specialist. The only supported user action is to move the Resource database. 

    To know when the Resource Database last updated just run the query;

    SELECT SERVERPROPERTY('ResourceLastUpdateDateTime');
    GO													
    
    

    The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema of every database. The Resource database does not contain user data or user metadata.

    Source: SQL Server BOL


    Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!
    • Proposed as answer by Tom Li - MSFT Tuesday, August 10, 2010 10:43 AM
    • Marked as answer by Tom Li - MSFT Tuesday, August 17, 2010 1:18 PM
    Monday, August 9, 2010 9:42 AM
  • Thanks,  What is the benefit of resource database....If there is a benefit of upgradation then how to do that or if SQL Server system objects are persisting in this then  master has already this...
    Monday, August 9, 2010 12:04 PM
  •  

    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.
    • Similarly, rolling back system object changes in a service pack only requires overwriting the current version of the Resource database with the older version

    Source: SQL Server BOL


    Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!
    Monday, August 9, 2010 12:43 PM