update: There was an auto restart this morning and I dint see any errors after that successful auto restart
But a couple of weeks back I had my SAN Admin carve out a LUN for 40GB from Raid 1 group and moved tempdb to that T:\ drive. The move went well and I restarted services after that. And right now I see the T:\ Drive at 8.0GB.
This morning there was a sql service auto restart because of contention/issues in tempdb and when I query
SELECT name, physical_name FROM sys.master_files WHERE database_id = 2
I see the below result and the space on c:\ drive went down by 8.0GB
tempdev C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempdb.mdf
templog C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\templog.ldf
Can some one please tell me why did that move back to c:\ drive?? and is there a way to fix this permanently.
Thanks a bunch
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams