I have been tasked with updating our DR documentation, which has gotten woefully out of
date. My only question concerns the resource database. In SQL Server 2005, it was among the
system databases and had to remain in the same location as the master database. In SQL Server
2008, it was moved to the bin folder in the SQL Server install directory.
Am I correct in assuming that the resource database contains only objects, but no data? If this
is so, can I safely ignore this database for purposes of DR, as long as my DR server is at the same
release level(service pack, CU, etc.) as my production server? If I must account for the resource
database, how do I go about it. I know I cannot backup the database, but must copy the data
and log files, but do I need to shutdown SQL Server before I do the copy? What order do I do the
restore? Do I restore the master database first, then the resource database, or do I restore the
resource database first, then the master?