Abi Chapagai (2/11/2011)
Good question though I got it wrong. I thought i would be able to move the resource database in SQL Server 2008. After i got it wrong, i tried moving the resource data and log file in different drive and i was not able to start the sql server service then which proved that we cannot move the resource database to different drive. Good one and learnt a new lesson today. I am still not convinced though, if we could move other system databases, why we cannot move the resource database inSQL 2008?Thanks,
The best answer I could find to that was here:
which shows that SQL Server 2008+ has a hardcoded process at startup that attaches the resource database from the same location as the executable file*, but doesn't explain why Microsoft has chosen to make it do that. I haven't seen a reason from Microsoft.
*This implies that you may be able to move a resource database if you also move the SQL Server executable... any brave hearts with unimportant SQL 2008+ boxes want to try it? :w00t: