May 20, 2008 at 10:41 am
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\mssqlsystemresource.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\mssqlsystemresource.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.
May 20, 2008 at 11:07 am
did you apply a service pack before or after doing this, I know I have seen the ldf file for this base be recreated during a patch if it is not in the same directory as the master.mdf\ldf file, push comes to shove I am assuming you can move this back?
Andrew
May 20, 2008 at 11:33 am
i did attempt sp2 after moving the files.
when you say 'move it back'? i don't know what you mean...
May 20, 2008 at 11:46 am
Did you keep a copy of the original files, if so you can issue the alter command again and point back to the older files, I have a feeling that the patch has recreated the .ldf file and thus the .mdf and .ldf now don't match.
May 20, 2008 at 11:51 am
I did not make a copy of the files before attempting to apply the service pack if that is what you mean.. are you always supposed to make copies of those two files when doing service packs?? as you can see.. i don't have much experience with 2005...
May 20, 2008 at 1:00 pm
what options do I have? I'm a little leary to just uninstall the instance?????????????
May 20, 2008 at 2:21 pm
Have you checked the access permisions for sql service account on this new mdf and ldf files location? Usually this message comes due to this only. Also, have master and mssqlsystemresource files in the same location.
Manu
May 20, 2008 at 2:27 pm
Turns out that installing SP2 created two new resource files (mdf ldf) in their original locations. I shutdown the service and moved them to where they are supposed to be and it's working (still testing but keeping my fingers crossed) live and learn.. AND DOCUMENT!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply