Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
hi
0%
0
Member Votes: 0, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
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: Tuesday, August 26, 2014 9:05 AM
Points: 47, Visits: 172
Hi,

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.

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 6:57 AM
Points: 21, Visits: 306
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