September 3, 2012 at 2:34 am
Hello experts,
i am having an instance for which Tempdb database files are located on a separate Drive called (F:) and other system and user DB files are located on a separate drive called (G:).
my question is, what if F: drive got crash and will become completely inaccessible.
as a DBA what will be my necessary actions
?
September 3, 2012 at 2:36 am
1. Stop SQL, replace the fault disks which make up the F drive, once all ok start SQL
2. Stop SQL, start SQL in Master only mode, alter the file locations for TempDB to a drive which is ok, Stop SQL, Start SQL in multi user mode.
September 3, 2012 at 2:41 am
but as tempdb will get corrupt, i guess it wont require to stop SQL server because it will automatically stoped ? and if tempdb is corrupt, will SQL start in any mode ? how?
September 3, 2012 at 2:46 am
Ok then "Ensure SQL is Stopped" as the first step.
And yes SQL will start if TempDB is corrupt as it is recreated every time SQL re-starts.
Your question was on what if the drive was inaccessable, not that TempDB was corrupt.
September 3, 2012 at 2:50 am
ok, got it thanks a lot 🙂
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply