Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Starting SQL Server in Minimal Configuration Expand / Collapse
Author
Message
Posted Monday, April 09, 2007 10:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 1:50 PM
Points: 214, Visits: 360
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jDave/2963.asp
Post #356913
Posted Thursday, May 10, 2007 5:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Thursday, May 10, 2007 6:35 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, July 28, 2013 3:59 PM
Points: 86, Visits: 255
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
Posted Thursday, May 10, 2007 6:58 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 9:01 AM
Points: 6,705, Visits: 1,680
Nice write up.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #364683
Posted Tuesday, April 15, 2008 8:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 9:54 AM
Points: 48, Visits: 169
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
Posted Wednesday, August 13, 2008 8:23 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:48 AM
Points: 2,507, Visits: 3,645
CAn anyone please explain what is -c and -f ???
Post #552388
Posted Thursday, August 14, 2008 1:29 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 12:20 PM
Points: 41,529, Visits: 34,445
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
Posted Thursday, August 14, 2008 3:46 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:48 AM
Points: 2,507, Visits: 3,645
Thanks :)
Post #552517
Posted Thursday, August 14, 2008 3:58 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:48 AM
Points: 2,507, Visits: 3,645
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 »

Add to briefcase

Permissions Expand / Collapse