Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    288

    Unanswered: instance will not come up after moving resource db files

    after moving the resource database files with this command:


    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');
    GO

    I am getting this error trying to do anything in the instance while I have it started in minimal mode (/f /t3608)

    (the instance WILL NOT COME UP UNLESS I USE THE /F /T3608 from a command promt.. please .. any suggestions??????????????????????
    Also.. I checked and the primary file is NOT READ-ONLY.

    File activation failure. The physical file name "E:\MSSQL\KOCSQLDEV01\Datafiles\mssqlsystemresourc e.ldf" may be incorrect.

    The log cannot be rebuilt when the primary file is read-only.

    File activation failure. The physical file name "E:\MSSQL\KOCSQLDEV01\Datafiles\mssqlsystemresourc e.ldf" may be incorrect.

    The log cannot be rebuilt when the primary file is read-only.

    Msg 945, Level 14, State 2, Line 1

    Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

    Msg 5069, Level 16, State 1, Line 1

    ALTER DATABASE statement failed.

  2. #2
    Join Date
    Dec 2007
    Posts
    288
    maybe I can ask this.. should re-install or un-install then reinstall? with the Instance not working at all - i don't know which is safer?

    or.. if I restore the other system databases will it recreate the resource DB?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •