Post reply

SQL Server Startup Options

  • June 9, 2013 at 11:46 am

    #294303

    Hi All,

    Can anyone tell me what the -F startup option does? I can't seem to find anything online for this :S

    Cheers,

    [font="Times New Roman"]There's no kill switch on awesome![/font]

  • June 9, 2013 at 12:47 pm

    #1622276

    -F or -f?

    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

  • June 9, 2013 at 12:58 pm

    #1622278

    -F

    Im not sure it even exists if i'm honest. I know -f but that's for BCP format file....

    [font="Times New Roman"]There's no kill switch on awesome![/font]

  • June 9, 2013 at 1:11 pm

    #1622279

    -f on the SQL Server executable is not a format file setting. It's minimal configuration startup option.

    The -f parameter on BCP.exe specified a format file, and on BCP.exe -F specifies which row of the import file to start with

    Are you asking about SQL Server startup parameters? SQLCMD? BCP? Something else

    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

  • June 9, 2013 at 1:19 pm

    #1622280

    GilaMonster (6/9/2013)

    -f on the SQL Server executable is not a format file setting. It's minimal configuration startup option.

    The -f parameter on BCP.exe specified a format file, and on BCP.exe -F specifies which row of the import file to start with

    Are you asking about SQL Server startup parameters? SQLCMD? BCP? Something else

    I'm talking about startup options. I think I've misunderstood what this guy was saying, -f looks to be what I was thinking.

    Thanks for the clarification 🙂

    [font="Times New Roman"]There's no kill switch on awesome![/font]

  • June 9, 2013 at 1:48 pm

    #1622282

    In that case, -f is documented at http://msdn.microsoft.com/en-us/library/ms190737.aspx

    Starts an instance of SQL Server with minimal configuration. This is useful if the setting of a configuration value (for example, over-committing memory) has prevented the server from starting. Starting SQL Server in minimal configuration mode places SQL Server in single-user mode.

    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

Viewing 6 posts - 1 through 5 (of 5 total)

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