January 5, 2009 at 9:43 pm
hi folks,
I restored the master database on a different machine and now the service won't start. In the event log I am getting:
Event Type:Error
Event Source:MSSQL$SPARE
Event Category:(2)
Event ID:17204
Date:6/01/2009
Time:2:08:36 PM
User:N/A
Computer:AUBRIDESQL01
Description:
FCB::Open failed: Could not open file d:\Program Files\Microsoft SQL Server\MSSQL.19\MSSQL\DATA\mssqlsystemresource.mdf for file number 1. OS error: 2(The system cannot find the file specified.).
how do I fix this?
January 5, 2009 at 10:30 pm
Hope you know that there is one More system database called Resource Db
http://technet.microsoft.com/en-us/library/ms190940.aspx%5B/url%5D
that is required in the Path
d:\Program Files\Microsoft SQL Server\MSSQL.19\MSSQL\DATA\mssqlsystemresource.mdf
you just need to copy and paste that in the path
January 6, 2009 at 5:36 pm
thank-you
because the master db was on a new server and did not have that path I fixed the problem by changing the location of the system database file using ALTER DATABASE
January 7, 2009 at 2:38 am
BOL asys you can move master and mssqlsystemresource. SP2 assumes it is in the default location and will leave you with an unstartable SQL Server if they have been moved. OK, you can normally start SQL in single user mode and hack the database locations, but taken as a whole moving master or mssqlsystemresource is a high-risk operation.
As you have restored master from another server, my advice is to make sure the mdf and ldf files for both master and mssqlsystemresource are in the default locations for the new SQL Server instance. The default location in this case is the location they were put in when you installed SQL Server.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply