|
hai, I recently altered the size of system database in order save the space. After restarting the services i couldnot start the MSSQLSERVICES. when i checked the errorlog it shows the error
i understood the problem is with templog.ldf .I tried replacing the LDF file from another system. But once the i try start services the size is going to zero and the services are also not starting. All i need to know is, is there any location where all the issued commands will be stored(Like text or XML file) where i can change the run time value for templog.ldf to assert its size. is there any possibilty to rectify the problem without re-installation... Thanks .....
(comments are locked)
|
|
How did you alter the sizes of the system databases? Which system databases did you alter? TempDB is recreated every time the service starts, so copying a tempdb.ldf from another system should neither help nor hinder. Is there enough disk space on the D: drive to create the tempdb log file? Yes the same problem indeed... I am familiar that tempdb is created every time the instance starts... Just i have given a try... and I have altered the size of templog.ldf by issuing ALTER DATABASE TempDb MODIFY FILE(NAME='TempDev',SIZE=0) & ALTER DATABASE TempDb MODIFY FILE(NAME='Templog',SIZE=0). My Drive have 8GB of Disk Space...
Jun 24 '11 at 02:17 AM
GMC
Do you have a backup copy of master?
Jun 24 '11 at 02:19 AM
Kev Riley ♦♦
did you try @Pavel's suggestion of attempting to start the server with th
Jun 24 '11 at 02:29 AM
Kev Riley ♦♦
If you had a backup of master, you could have restored it - it is in master where the config for tempdb is stored. One option is to reinstall and then reattach the user databases
Jun 24 '11 at 02:52 AM
Kev Riley ♦♦
SQL stores a lot of data about itself in the master database - not external files. It will generate the TempDB based on the values it holds in master. Do you mean backup the master from another system, and try and restore that? Probably give you more issues than a simple reinstall.
Jun 24 '11 at 03:16 AM
Kev Riley ♦♦
(comments are locked)
|
|
The problem relates to there not being enough drive space where the tempdb file is located. We moved one of the databases on that drive away to another drive, started the SQL service successfully and reattached the moved database. Alternative is to grow the drive where the database is located.
(comments are locked)
|


Is this related to this question http://ask.sqlservercentral.com/questions/74813/sql-services-not-getting-restarted