Restoring/Recovering Master db

• gk-411903

  Hall of Fame

  Points: 3801

  More actions

  July 22, 2008 at 4:50 pm

  #210263

  Hello Experts

  This is a test db not production SS2005.

  I have full backup of the master db and tried simulating a crash;

  - Stopped the service

  - renamed master.mbf and mastlog.ldf

  - tried starting up the service/default instance MSSQLSERVER in single user mode as follows

  cd f:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

  .\sqlservr.exe -m

  It gives Error 17113 ; Says cannot find the /master.mdf.

  I tried as per the url

  http://sql-articles.com/articles/rebuildsysdb.html

  Step2 => start /wait .. command

  It slept for 2 minutes and exitted normally; No new files (master*.f) were created in Data directory.

  I have two questions in this regard.

  Q1: What is that i am missing?

  Q2: Should master / model / msdb be backed up using File group/ files? But the Enterprise Manager greys it out once i choose System Database;

  Any ideas?

  Thanks in advance.

• Venkatesan Prabu

  SSCommitted

  Points: 1892

  More actions

  July 27, 2008 at 2:17 am

  #848879

  You have missed out Stopping the server. 🙂

  Thanks and Regards,
  Venkatesan Prabu, 😛
  My Blog:

  http://venkattechnicalblog.blogspot.com/