September 23, 2009 at 11:39 pm
Hello All,
One of the logical drive of my server where both mdf and ldf files of temp DB was resising crashed last night and we had to replace this drive. These files could be recovered and the SQL server service is not starting now.
Is there anyway I can make the things working again?
Thanks in advance
September 23, 2009 at 11:52 pm
September 24, 2009 at 12:06 am
Actually I do not have those mdf and ldf files to put back
September 24, 2009 at 12:22 am
Ziljan4 (9/24/2009)
Actually I do not have those mdf and ldf files to put back
But in your original post you said these files can be recovered?
The reason I asked this is because if you had any process in fly you could loss them.
Talking about TempDB in particular, SQL does not care if the tempDb files are there or not. If it doesn't get the files it creates a new one subjected to original path exists.
If you are not able to start your SQL Services, the reason maybe something else. Can you tell us what error are you getting?
September 24, 2009 at 1:45 am
As mentioned before, the tempdb database is recreated every time sql server is restarted. post the error that is occurring and we can help you further.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply