13 Examples of Answers to SQL Server Application Questions (2)_PHP Tutorial

Question: What should I do if there is an error in the configuration of Tempdb In Ram?
Answer: SQL Server provides a mechanism to store Tempdb in memory to improve system efficiency. However, if the value of "Tempdb In Ram" is set too large, SQL Server will not start normally. If you encounter this kind of problem, you can:
Start SQL Server in minimum resource mode at the command line prompt (for example: C:MSSQLBINNSQLSERVR-f).
Switch to the Windows interface, connect to SQL Server through ISQL_W as the SA account, and execute the following commands.
Sp_configure'Allow Update', 1
Reconfigure with override
Go
Sp_configure'Tempdb In Ram', 0
Go
Sp_configure'Allow Update', 0
Reconfigure with override
Use Ctrl-C to terminate the SQLSERVR program running on the command line. Start SQL Server again in the usual way.
At this time, Tempdb is created on the disk and the size is about 2M. At this time, Tempdb can be adjusted to the appropriate size through SQL Enterprise Manager.
Question: What should I do if "Error 1069, the service cannot be started due to login failure" occurs when starting MSSQLSERVER or SQLEXECUTIVE?
Answer: Select 'Service'MSSQLSERVER/SQLEXECUTIVE'Start...' in the control panel and check whether the account name and password are correct.
Question: What is the purpose of using Setup /t RegistryRebuild = On when installing SQL Server?
Answer: Using this parameter in the Setup command will only rewrite the key values ​​used by SQL Server in the registry without reinstalling SQL Server.