Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Missing Drives on Remote server Expand / Collapse
how to find missing drives using T-SQL
Poll ResultsVotes
Member Votes: 0, Anonymous Votes: 0. You don't have permission to vote within this poll.
Posted Monday, October 7, 2013 10:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, December 5, 2014 8:50 AM
Points: 47, Visits: 219

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.

Post #1502264
Posted Thursday, October 10, 2013 1:03 PM


Group: General Forum Members
Last Login: Wednesday, February 18, 2015 10:22 AM
Points: 21, Visits: 313
You need to log on that server and checked it out is there Drive still there or not if not check you windows log.
In worst case if it is gone or not in repairable then you need to re-add that Drive
Post #1503756
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse