SQL Server application Problem Solving 13 cases (ii)

Server| Solution | Question: What if the configuration of Tempdb in RAM goes wrong?


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
Large, which can cause SQL Server to not start properly. If you encounter this type of problem, you can:


Start SQL Server (for example, C:\MSSQL\BINN\SQLSERVR-f) in the minimal resource mode at the command line prompt.


Switch to the Windows interface, connect to SQL Server via Isql_w with 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 that is running on the command line. Start SQL Server again in the usual way.


The tempdb at this time is built on disk and is about 2M in size. You can then adjust tempdb to the appropriate size through SQL Enterprise Manager.


Q: What happens when you start MSSQLServer or SQLExecutive with error 1069, unable to start the service because of a logon failure?


A: Select ' Service ' mssqlserver/sqlexecutive ' start ... ' in the Control Panel to check that the account name and password are correct.


Q: What is the use of 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.