master db restore

Last Post 08 Jan 2010 06:32 AM by Markus_SQL. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Markus_SQL
New Member
New Member

--
05 Jan 2010 05:46 AM
On our Development server I am documenting the exact steps on how to restore the master db. This is Win2008/SQL 2008 SP1 64 bit

I shutdown all SQL Server services for INST4.

cmd prompt and navigate to the INST4 binn directory

enter sqlservr.exe -m -s INST4 and get this message:

initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).

I am logged onto the server with the ID that runs the SQL Server service and if I use the SERVICES it starts just fine which is what is odd. It CAN find the system path started via the SERVICES but not at command prompt. Any help would be appreciated.
Markus_SQL
New Member
New Member

--
08 Jan 2010 06:32 AM
Yep, after doing some research I did find that and it works.
Markus_SQL
New Member
New Member

--
12 Jan 2010 06:28 AM
I finally figured out my problem. When you open up CMD prompt on Win2008 you need to right click on it and say RUN AS ADMIN.


Acceptable Use Policy
---