I wanted to shift tempdb from 0+1 to raid 0 array. I am not worrid about the transactions or rollback. if tempdb raid 0 array crashes, and I put new disk raid 0 array in place of crashed one will server start without any problems? Any other concerns except the transactions are losts.
RE: Very surprising no reply.....
Q1 If tempdb raid 0 array crashes, and I put new disk raid 0 array in place of crashed one will server start without any problems?
Well, some folks are on holidays; but here is a quick answer:
It is best to extensively test any new configuration (especially less redundant ones) for failure recovery issues prior to implementation. Some obvious considerations in this case would pertain to what else may reside on the tempdb raid 0 array with tempdb e.g.(if Model, Master, etc., or some transaction logs of production DBs reside on the same array, there will be various different issues to address). One may also expect possible issues related to how production DBs / stored procedures, etc., will fail in an environment that suddenly loses tempdb with many production stored procedures in progress. For example, it is possible that some production stored procedures have been written in ways that may cause issues with inconsistent data in production DBs (in the event of the sudden loss of tempdb during a period of high production activity). Barring such kinds of issues, tempdb is rebuilt from the model DB each time Sql Server services start up normally (incidentally, ver. 6.5 supports tempdb in ram).