locked
system error 1067 has occurred the process terminated unexpectedly ? RRS feed

  • Question

  • Hi All,

    recently we build a one sql server 2005 (standalone server) after  instillation i changed the system databases paths (MASTER, Model,Tempdb, MSDB) . when i  try to move the resource database, i followed below steps

    1. i stopped the sql server services

    2.. i run this command in command prompt below like this

    net start MSSQL$instance name /f /t3608

    after that i get this error

      system error 1067 has occurred the process terminated unexpectedly

    how can i troubleshoot this error

    please share your views with me on this error....

    Thanks


    RAM

    • Edited by TSRam Wednesday, September 21, 2011 7:34 PM
    Wednesday, September 21, 2011 6:31 PM

Answers

  • Did you follow the step by step as from this link - http://msdn.microsoft.com/en-us/library/ms345408(v=SQL.90).aspx to do the move of your system databases as well as the resource databases ?

    Have you had a look at the event log for any errors and any errors in the SQL error log. Posts these up for people to also throw more information your way

     


    Warwick Rudd
    MCT MCITP SQL Server 2008 Admin
    My Blog
    • Edited by Warwick Rudd Wednesday, September 21, 2011 7:09 PM
    • Proposed as answer by amber zhang Friday, September 23, 2011 7:37 AM
    • Marked as answer by Stephanie Lv Wednesday, September 28, 2011 3:13 AM
    Wednesday, September 21, 2011 7:06 PM