I am looking to find missing drives on remote server. actually we are monitoring bulk servers, but we got some issue with one server that one drive is disapeared. we don't have any choice until it come to notice. later backups failures started and we identified drive is missed. can anyone help me to find those issue using T-SQL script. or even it would be better in anyway to find those issues.
Replays are most welcome.