Starting SQL Server in Minimal Configuration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Jay Dave » Starting SQL Server in Minimal Configuration

Starting SQL Server in Minimal Configuration

Rate Topic

Display Mode

Topic Options

Author

Message

sqldba-294117

Posted Monday, April 09, 2007 10:40 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:56 PM
Points: 214, Visits: 338

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

Post #356913

Jag Sandhu

Posted Thursday, May 10, 2007 5:00 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 01, 2011 5:12 AM
Points: 26, Visits: 52

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

Jag Sandhu

Post #364659

Regan Galbraith

Posted Thursday, May 10, 2007 6:35 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, June 10, 2013 9:28 AM
Points: 86, Visits: 253

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.

Post #364675

Andy Warren

Posted Thursday, May 10, 2007 6:58 AM

SSCertifiable

Group: Moderators
Last Login: Tuesday, June 11, 2013 6:34 AM
Points: 6,463, Visits: 1,388

Nice write up.

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #364683

SQLEE

Posted Tuesday, April 15, 2008 8:25 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 21, 2012 8:20 AM
Points: 46, Visits: 161

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...

Post #485062

Ratheesh.K.Nair

Posted Wednesday, August 13, 2008 8:23 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 9:39 AM
Points: 2,425, Visits: 3,401

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

Post #552388

GilaMonster

Posted Thursday, August 14, 2008 1:29 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:37 PM
Points: 38,028, Visits: 30,334

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 2008, MVP
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

Post #552456

Ratheesh.K.Nair

Posted Thursday, August 14, 2008 3:46 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 9:39 AM
Points: 2,425, Visits: 3,401

Thanks :)

Post #552517

Ratheesh.K.Nair

Posted Thursday, August 14, 2008 3:58 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 9:39 AM
Points: 2,425, Visits: 3,401

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...

Post #552522

« Prev Topic | Next Topic »

Permissions