Not to mention the command is for a default SQL Instance. Let me show you by starting SQL Server with -f parameter: -f puts SQL In single user mode That means you don’t have to specify -m ( Single user Mode) explicitly when you are using -f. At the same time the text “Starting SQL Server in minimal configuration mode places SQL Server in single-user mode” is self explanatory. With this in mind I shall explain with example what it actually means. And if you are not so experienced in SQL Server I could imagine your facial expression. Make sense? This is exactly what is written in Microsoft Documentation. Starting SQL Server in minimal configuration mode places SQL Server in single-user mode. The parameter -f 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. First let’s warm you up with the well known facts about the parameter. This article is about very interesting facts about SQL Server startup parameter “-f”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |