August 27, 2003 at 1:16 pm
Does anyone know of a way to start the sql service when the drive that holds tempdb is out of commission?
Would starting the service manually with minimal configuration allow me to change the location of where tempdb is located?
August 27, 2003 at 1:30 pm
Replace the failure drive and start SQL Server, TempDB will be recreated.
If you want to move TempDB to another location, See http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
August 27, 2003 at 1:35 pm
You can start SQL with minimal configuration (sqlservr -f) and then you can change the location of tempdb file.
August 27, 2003 at 1:36 pm
I have space on another drive array that is working properly, I was hoping to find a way to get SQL Server up while the hardware problem on the 2nd array of disks (tempdb)is being addressed.
August 27, 2003 at 1:37 pm
Have you tried doing the minimal config to change the location of tempdb?
August 27, 2003 at 1:45 pm
Yes, I did it once.
When you start sql server with minimal it creates the tempdb in the default directory (C:\Program Files\Microsoft SQL Server\MSSQL\Data), then you can connect with query analizer and change the location of the tempdb.
August 27, 2003 at 1:46 pm
Thanks a lot. I'll give it a try.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply