SQL SERVER application answers 13 cases (2)

Q: What should I do if the configuration of Tempdb In Ram is incorrect?
A: SQL Server provides a mechanism to store Tempdb in memory to improve system efficiency. However, if you set the value of "Tempdb In Ram"
SQL Server cannot be started normally. If you encounter such problems, you can:
Run the command line prompt to start SQL Server in the minimum resource mode (for example, C: MSSQLBINNSQLSERVR-f ).
Switch to the Windows interface, use the SA account to connect to SQL Server through ISQL_W, and execute the following command.
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. Restart SQL Server as usual.
At this time, Tempdb is created on the disk and the size is about 2 MB. In this case, you can use SQL Enterprise Manager to adjust Tempdb to a proper size.
Q: When MSSQLSERVER or SQLEXECUTIVE is started, what should I do if "Error 1069 cannot be started due to logon failure?
A: On the control panel, select 'service' MSSQLSERVER/SQLEXECUTIVE to start... 'To check whether the account name and password are correct.
Q: What is the purpose of Setup/t RegistryRebuild = On when installing SQL Server?
A: When using this parameter, the Setup command will only overwrite the key values used by SQL Server in the Registry without re-installing SQL Server.