February 12, 2009 at 2:35 am
Dear all,
For a yet unknown reason our SQL Server 2005 stopped at 3:00am this morning.
When I tried to start it, it complained about mssqlsystemresource being the wrong file (or corrupted)...
2009-02-12 08:46:44.40 spid5s Log file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mssqlsystemresource.ldf' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.
2009-02-12 08:46:44.40 spid5s The log cannot be rebuilt when the primary file is read-only.
2009-02-12 08:46:44.40 spid5s Error: 945, Severity: 14, State: 2.
2009-02-12 08:46:44.40 spid5s Database 'mssqlsystemresource' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Before failing to load that database, it tells me that "The resource database build version is 9.00.3068"
Having checked on my personal laptop, my resource database is build 9.00.3073.
Would there be any harm in trying to load with my slightly more recent version of the resource database instead of the "corrupt" one?
Thanks
Eric
PS: This is not a Production system
February 12, 2009 at 4:45 am
In the end, it looks like there was a failed Security Update for Sql Server 2005 sp2 and we were lucky that there seemed to be a second set of System Resources database files (named mssqlsystemresource1.mdf and mssqlsystemresource1.ldf) and we just got away by replacing the originals.
They happened to be exactly the same version as Sql Server tried to load.
Sorted!
😀
PS: entry in Event Viewer
Installation Failure: Windows failed to install the following update with error 0x80070643: Security Update for SQL Server 2005 Service Pack 2 (KB960089).
February 12, 2009 at 7:32 am
... and that is exactly the reason why the mssqlsystemresource.* should be backed up manually after any upgrade..... Just as a reminder, this DB is in the same location as the master DB.
April 7, 2010 at 8:23 pm
Many thanks SSC Eights, in this way the problems solved today.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply