Resource database is a system database which is not accessible during normal operations.It is a read only database that contains all system objects used by an SQL server.It is logically presented as system schema in every database. It contains the structure and description of all system objects and no user data.
This database helps to roll back the service pack installation very easily. All you have to do is before SP installation just make a copy of this database so that you can replace the new resource database with old one if needed.
This concept introduced in SQL 2005.
No comments:
Post a Comment