Hi, In sqlserver to shrink the tempdb I issued a command, alter database tempdb modifyfile (name = 'tempdev',size = 0) commands completed successfully. alter database tempdb modifyfile (name = 'templog',size = 0) commands completed successfully. after doing this I opened command prompt and issued net stop mssqlserver services have been stopped successfully. I have issued net start mssqlserver after this it is trowing error a service specific error occurred 1814 I am not able to start the services pls suggest on this. waiting for the response........ Thanks in advance.
The error is related to the fact, that SQL Server instance cannot create a TEMP DB. It seems to be related to the fact, that you have set the size of TEMP DB to 0. So it cannot create a TEMP DB of size 0. Why you have set the initial size of temp db to 0? You can try to fix the issue by starting the sql server from command line with `-c -f` startup options. Then try to connect to the server, specify a correct temp db size. After that stop the service and start it normally. Didn't tested this scenario, so maybe will not work for this kind of issue.