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