Starting SQL Server in Minimal Configuration

  • Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jDave/2963.asp

  • What was ' MAX SERVER MEMORY' before??????


    Jag Sandhu

  • Nice recovery from a nasty situation. I did not know that would cause SQL not to start. I'll be adding that to my 'by the way' notes for future reference.

  • Nice write up.

  • Nice work. In your case you already know what might have happened by resetting the Max Memory. My question is what if you don't know that was the cause of SQL shutting down? Can you think of how would you troubleshoot, look for behaviors etc...

  • CAn anyone please explain what is -c and -f ???

  • Ratheesh.K.Nair (8/13/2008)


    CAn anyone please explain what is -c and -f ???

    Look in Books online under the section "Using the SQL Server Service Startup Options". It lists all of the command switches and what they do.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    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
  • Thanks 🙂

  • When i tried servr -c -f ,i got error

    "Your sql server installation is either corrupt or has been tampered with(SQL Registry Version Not Same as Server)Please uninstall then re-run setup to correct this problem...

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply