Most importantly the ID of resource database is always 32767. Resource database consists of two files namely mssqlsystemresource.mdf and mssqlsystemresource.ldf. ![]() However, resource database will only store system objects and you cannot store user data or metadata. System objects such as sys.objects are physically stored in Resource Database which appears logically in the SYS schema of each database. Resource database is a read-only system database which is hidden from users. ![]() It’s a read-only system database which is hidden from users and in this article we will discuss how to backup and restore Resource Database in SQL Server.ĭBAs should backup Resource Database along with other System Databases in SQL Server as part of Disaster Recovery and most importantly document the location of each and every system and user databases. Microsoft SQL Server 2005 introduced a new system database namely Resource database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |