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 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply