Link to home
Create AccountLog in
Avatar of SP_2018 .
SP_2018 .Flag for United States of America

asked on

How to move resource database(hidden) to a different drive

Hi,

Recently i moved all systems and user databases to different location,
All data files were in one drive and the log files were moved to another drive.
I have read that master and resource databases have to reside in one location
but when i issue the below command it gives an error.
Please advise the procedure to move resource database.

ALTER DATABASE mssqlsystemresource
    MODIFY FILE (NAME=data, FILENAME= 'D:\Data\mssqlsystemresource.mdf');
GO
ALTER DATABASE mssqlsystemresource
    MODIFY FILE (NAME=log, FILENAME= 'E:\Log\mssqlsystemresource.ldf');

Error:

Msg 911, Level 16, State 1, Line 1
Database 'mssqlsystemresource' does not exist. Make sure that the name is entered correctly.


Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Tony303
Tony303
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account