SQL Server Startup Options
-
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] -
-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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
-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] -
-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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
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] -
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 recoverabilityWe 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