May 30, 2011 at 8:29 am
My IT manager is going to replace all SAN disks (lease is over),
i.e. C: disk will be intact (with OS and Sql server 2005) but D: (log), E: (Data) and F: (2-nd TempDB file) will be replaced.
As far as User DB there is no problem- backup/restore, but frankly I am not sure how to manage 2-nd TempDB file.
I mean if I’ll do nothing and 2-nd file (TempDB) will disappear (at least temporarily-
sorry for tautology :-P) I am not sure Sql Server will be online after disks replacement
(i.e. I can start User DB restore).
What options do I have- 1) delete 2-nd TempDB file and later recreate it when new F: disk will be available; 2) move 2-nd TempDB file to C: and later back to F: 3) something else?
Please advice.
Thanks,
May 30, 2011 at 8:57 am
for Tempdb you don't need to do anything. Tempdb is recreated each time SQL Server starts. It does however rely on the model database being available.
If you remove the current TempDB drive and put in a new one just remember to recreate the drive letter, file path and security and Tempdb will get recreated.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2011 at 9:14 am
Perry,
Yes, I know that TempDB is recreated each time Sql Server restarted but just to be sure I got you:
if I keep mdf TempDB file and for ndf one I create same folder as it was before on new disk
then Sql Server automatically will recreate ndf tempDB file with no my extra action required.
Correct?
Thanks, Yuri
May 30, 2011 at 9:25 am
Yuri55 (5/30/2011)
Perry,Yes, I know that TempDB is recreated each time Sql Server restarted but just to be sure I got you:
if I keep mdf TempDB file and for ndf one I create same folder as it was before on new disk
then Sql Server automatically will recreate ndf tempDB file with no my extra action required.
Correct?
Thanks, Yuri
Yes, each file that is created for tempdb is recreated on each server restart.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 30, 2011 at 9:32 am
Great!
Thanks again, Yuri
May 30, 2011 at 9:38 am
You're welcome
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 30, 2011 at 10:13 am
again, I'll reiterate, as long as the model database is available
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply