How to start SQL Server with master database only?

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  November 17, 2006 at 11:04 am

  #116340

  In some cases, other databases are crashed. Is it possible to start SQL Server with only master database, and then, we can recovery other system and user databases?

  Many thanks in advance.

• November 20, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  November 22, 2006 at 7:07 am

  #673442

  Yes, there are some help for doing 'admin' starts, presumably used from a command prompt.

  start the sqlserver service from a prompt and use some or a combo of the following options;

  /m         starts in single user mode

  /f          starts in minimal configuration mode

  /T3608   starts and only recovers master

  BOL has more info on startup parameters.

  /Kenneth