Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vijaynd2003
Starting Member
1 Post |
 Posted - 2003-12-07 : 08:03:08
|
| Hi,I have done a big mistake. My SQL SERVER 6.5 was runing smoothly. Without having detailed idea, I just fingured the SERVER CONFIGURATION & changed the memory value to 64MB & tempdb in RAM value to 3 MB. After restarting my server, I m not able to start the MSSQLserver service. When I try to start it manually it gives an error 'Error 2140: An internal Windows NT error occurred'.I even tried to start the server by 'sqlservr -c -f' command & then change the memory & tempdb values from ISQL_W utility (login as 'sa') with following commands (found it on support/microsoft page : 173090 - INF) :sp_configure memory, 8192 sp_configure tempdb, 0on executing the above commands I get error message as :Msg 615, Level 21, State 1Unable to find database table id = 2, name = 'tempdb'The SQL Server is terminating this process.What should I do next ? I m in a desparate need of your help. Plssssss. help me.Thanks in advance.Vijay |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-08 : 12:22:41
|
| Sounds like tempdb is now messed up. Do you have full backups of your databases? If so, I would start rebuilding SQL Server by uninstalling it, then reinstalling, then restoring your backups.Tara |
 |
|
|
|
|
|
UNABLE TO START MS SQL SERVER 6.5