Many people ask the question: Why does Identity Value Jump after restarting SQL Server? In this article, we will provide a solution to eliminating this unwanted jumping. It is one of the common FAQs. Let me create a table and insert a new record.
If any reason restarts your SQL Server Instance, the identity column will insert 1000, 10000, etc.
Solution: Identity Value Jumps after restarting SQL Server
Go to the SQL Server Configuration Manager. Next, right-click the Instance Name and select the properties from the context menu.
Selecting the properties window will open the following window.
Go to the Startup Parameters Tab and add -T272.
Click Apply.
Click OK and restart the SQL Server instance.