Q: What happens to the configuration of Tempdb in RAM?
A: SQL Server provides a mechanism for storing tempdb in memory to improve system efficiency. However, if you set the value of the "Tempdb in Ram"
Causes SQL Server to fail to start properly. If you encounter this type of problem, you can:
Start SQL Server (for example: c:mssqlbinnsqlservr-f) in minimal resource mode at the command prompt.
Switch to the Windows interface, connect to SQL Server with the SA account through Isql_w, 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 that is running on the command line. Start SQL Server again in the usual way.
At this point, tempdb is built on disk with a size of approximately 2M. You can then resize tempdb to the appropriate size through SQL Enterprise Manager.
Q: What should I do when I start MSSQLServer or SQLExecutive with "error 1069, unable to start service due to login failure"?
A: In the Control Panel, choose ' Service ' mssqlserver/sqlexecutive ' start ... ' to check that the account name and password are correct.
Q: What is the purpose of using setup/t RegistryRebuild = ON when installing SQL Server?
A: The Setup command uses this parameter to override only the key values that SQL Server uses in the registry without reinstalling SQL Server.
http://www.bkjia.com/PHPjc/631216.html www.bkjia.com true http://www.bkjia.com/PHPjc/631216.html techarticle Q: What happens to the configuration of Tempdb in RAM? A: SQL Server provides a mechanism for storing tempdb in memory to improve system efficiency. However, if you set the value of "Tempdb in Ram" to ...
