SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Starting SQL Server in Minimal Configuration


Starting SQL Server in Minimal Configuration

Author
Message
sqldba-294117
sqldba-294117
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2464 Visits: 396
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jDave/2963.asp
Jag Sandhu
Jag Sandhu
SSC-Enthusiastic
SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)SSC-Enthusiastic (114 reputation)

Group: General Forum Members
Points: 114 Visits: 52

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






Jag Sandhu

Regan Galbraith
Regan Galbraith
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3669 Visits: 265
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.
Andy Warren
Andy Warren
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Moderators
Points: 62317 Visits: 2803
Nice write up.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
SQLEE
SQLEE
Right there with Babe
Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)Right there with Babe (739 reputation)

Group: General Forum Members
Points: 739 Visits: 207
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...
VastSQL
VastSQL
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24513 Visits: 5726
CAn anyone please explain what is -c and -f ???
GilaMonster
GilaMonster
SSC Guru
SSC Guru (671K reputation)SSC Guru (671K reputation)SSC Guru (671K reputation)SSC Guru (671K reputation)SSC Guru (671K reputation)SSC Guru (671K reputation)SSC Guru (671K reputation)SSC Guru (671K reputation)

Group: General Forum Members
Points: 671128 Visits: 48432
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


VastSQL
VastSQL
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24513 Visits: 5726
Thanks Smile
VastSQL
VastSQL
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24513 Visits: 5726
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...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search