Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Restoring master database Expand / Collapse
Author
Message
Posted Wednesday, May 21, 2014 8:41 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:19 AM
Points: 456, Visits: 1,682
Sorry for the duplicate post.
Post #1573219
Posted Wednesday, May 21, 2014 8:58 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:06 PM
Points: 2,569, Visits: 3,809
Beatrix Kiddo (5/21/2014)
Talk us through what you've done so far.

So: have you opened a command prompt window and navigated to the location of the BINN folder for your 2008 instance?

If you have, please post the syntax you are using to try to start the 2008 instance.


Thanks Beatrix.

You are right after that i ran 'Sqlservr.exe –T3608'
Post #1573229
Posted Wednesday, May 21, 2014 9:04 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:19 AM
Points: 456, Visits: 1,682
Try Sqlservr.exe -m

or Sqlservr.exe -m -s INSTANCENAME if it's a named instance
Post #1573234
Posted Wednesday, May 21, 2014 9:04 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:19 AM
Points: 456, Visits: 1,682
(again)
Post #1573235
Posted Monday, May 26, 2014 4:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:06 PM
Points: 2,569, Visits: 3,809
Thanks Beatrix,

I got the below messages.

C:\Program Files\Microsoft SQL Server\MSSQL10_50.R8\MSSQL\Binn>sqlservr.exe -m -
sR8
2014-05-26 16:14:33.41 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:33.41 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:33.71 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:33.71 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:34.01 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:34.01 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:34.31 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:34.31 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:34.62 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:34.62 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:34.92 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:34.92 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:35.22 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:35.22 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:35.52 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:35.52 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:35.82 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:35.82 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:36.12 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:36.12 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
Post #1574500
Posted Monday, May 26, 2014 5:47 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:21 PM
Points: 42,495, Visits: 35,566


See the section on 'can't create the error log.'



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1574503
Posted Monday, May 26, 2014 8:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:32 AM
Points: 6,196, Visits: 13,354
Ratheesh.K.Nair (5/26/2014)
Thanks Beatrix,

I got the below messages.

C:\Program Files\Microsoft SQL Server\MSSQL10_50.R8\MSSQL\Binn>sqlservr.exe -m -
sR8
2014-05-26 16:14:33.41 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:33.41 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:33.71 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:33.71 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:34.01 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:34.01 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:34.31 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:34.31 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:34.62 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:34.62 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:34.92 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:34.92 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:35.22 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:35.22 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:35.52 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:35.52 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:35.82 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:35.82 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).
2014-05-26 16:14:36.12 Server Error: 17058, Severity: 16, State: 1.
2014-05-26 16:14:36.12 Server initerrlog: Could not open error log file ''.
Operating system error = 3(The system cannot find the path specified.).

Check the startup paramters for the sql server service via sql server config manager or via the registry.

The hive location is

HKEY_Local_Machine\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.instancename\MSSQLServer\Parameters

The key to check is

SQLArg1


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1574535
Posted Friday, May 30, 2014 6:44 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:06 PM
Points: 2,569, Visits: 3,809
Thanks Gail and Perry.

The location exists and have access. I have given everyone full access to the location but still gets the same error.
Post #1576043
Posted Friday, May 30, 2014 7:01 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:21 PM
Points: 42,495, Visits: 35,566
The location does not exist. If it did, you wouldn't be getting this error:
The system cannot find the path specified.


You need to figure out where SQL is trying to create the error log (the registry key Perry mentioned should be it) and create the path SQL is expecting.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1576048
Posted Friday, May 30, 2014 12:53 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:32 AM
Points: 6,196, Visits: 13,354
Ratheesh.K.Nair (5/30/2014)
I have given everyone full access to the location but still gets the same error.

If inheritance is turned off you could see this issue. Open the security properties and under advanced options select the checkbox to force propogation to child objects then click apply.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1576249
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse