Missing mssqlsystemresource files – SQL Server 2014

I recently did 4 installs of SQL Server 2014 on two different servers.   When I checked the services I saw that on SQL Server did not start.  This is the error in the log:

2017-02-14 14:30:00.11 spid12s     FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL12.ABC\MSSQL\Binn\mssqlsystemresource.mdf for file number 1.  OS error: 2(The system cannot find the file specified.).

2017-02-14 14:30:00.11 spid12s     Error: 5120, Severity: 16, State: 101.

2017-02-14 14:30:00.11 spid12s     Unable to open the physical file “C:\Program Files\Microsoft SQL Server\MSSQL12.ABC\MSSQL\Binn\mssqlsystemresource.mdf”. Operating system error 2: “2(The system cannot find the file specified.)”.

2017-02-14 14:30:00.11 spid12s     Error: 17207, Severity: 16, State: 1.

The fix was simple, I copied the files from the other instance on the system and everything started up.  I have run into this before with other versions of SQL Server.  I have access to a lot of other systems so I can find them on other computers and copy them over.



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s