Thursday, October 24, 2013

DRIVES NOT LISTING ON SSMS WHILE CREATING MAINTENANCE PLAN

The Recently added Luns(added as drives from windows) were not getting listed in the cluster SQL Server.
When I tried backing up the database through scripts mentioning the newly added drives the backup was successful.When We we tried to create  a maintenance plan , I was not able to see the drives from there.

FROM SSMS New query window I issued XP_FIXDRIVES , I was able to see all the drives including the newly added drives .

To fix the issue ,

  • From the Cluster administrator brought the newly created drives offline.
  • Brought the SQL Services offline.
  • From the properties of SQL Services -->Dependencies -->Modify-->Added the drives.
  • Brought the SQL Services online.
  • Disconnected the Management Studio and connected back to Management  Studio.

Now I again tried to create maintenance plan, I was able to see the Drives Successfully. 

No comments:

Post a Comment