--
-- Information about system database
--

SELECT name, database_id FROM sys.databases 
WHERE database_id < 5

SELECT dbid, name, filename FROM sys.sysaltfiles
WHERE dbid < 5 OR dbid = 32767


--
-- Information about resource database
--

-- Version number of resource database
SELECT SERVERPROPERTY('ResourceVersion');
GO

-- When database was last updated
SELECT SERVERPROPERTY('ResourceLastUpdateDateTime');
GO

-- Definition of system views
SELECT OBJECT_DEFINITION(OBJECT_ID('sys.objects'));
GO


--
-- Move resource database (default instance)
--


-- 1 - Stop database engine (cmdline)

NET STOP MSSQLSERVER 


-- 2 - Start engine - master database mode (cmdline).

NET START MSSQLSERVER /f /T3608


-- 3 - Run SQLCMD to update location of resource database (cmdline).

ALTER DATABASE mssqlsystemresource 
    MODIFY FILE (NAME=data, FILENAME= 'c:\mssql\data\mssqlsystemresource.mdf');
GO
ALTER DATABASE mssqlsystemresource 
    MODIFY FILE (NAME=log, FILENAME= 'c:\mssql\log\mssqlsystemresource.ldf');
GO


-- 4 - Copy resource database file to new location (explorer)


-- 5 - Run SQLCMD to make sure resource database is read only (cmdline).

ALTER DATABASE mssqlsystemresource SET READ_ONLY;


-- 6 - Stop database engine (cmdline).

NET STOP MSSQLSERVER 


-- 7 - Restart database engine (cmdline).

NET START MSSQLSERVER 


-- 8 - Verify change by selecting from system catalog views (cmdline).

SELECT name, physical_name AS CurrentLocation, state_desc
FROM sys.master_files
WHERE database_id = DB_ID('master');
GO