Move Resource Database

• shree

  Say Hey Kid

  Points: 702

  More actions

  May 21, 2009 at 1:08 pm

  #134364

  Hi guys

  i was off way successfull in moving the SYSTEM Databases from one drive to other drive on the same server.

  i have successfully moved master ,temp,model and msdb databases but some reason i could not do this below step from the KB

  http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx

  I AM MISSING THIS BELOW STEP, It seems to be moved but i cannot delete the mssqlresource mdf and ldf files from the old location. can some one advise what' happening.

  See error

  Msg 911, Level 16, State 1, Line 1

  Could not locate entry in sysdatabases for database 'mssqlsystemresource'. No entry found with that name. Make sure that the name is entered correctly.

  Msg 911, Level 16, State 1, Line 1

  Could not locate entry in sysdatabases for database 'mssqlsystemresource'. No entry found with that name. Make sure that the name is entered correctly.

  name of the database or the file names.

  Copy Code

  ALTER DATABASE mssqlsystemresource

  MODIFY FILE (NAME=data, FILENAME= 'new_path_of_master\mssqlsystemresource.mdf');

  GO

  ALTER DATABASE mssqlsystemresource

  MODIFY FILE (NAME=log, FILENAME= 'new_path_of_master\mssqlsystemresource.ldf');

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736188

  More actions

  May 21, 2009 at 1:16 pm

  #998509

  http://decipherinfosys.wordpress.com/2009/02/12/moving-the-resource-database-in-sql-server-2005/