SQL SERVER application answers 13 cases (2)

Source: Internet
Author: User
Tags mssqlserver
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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.