Post reply

Can not access databases after NAS update

  • September 27, 2011 at 8:24 am

    #243786

    There was an update to the NAS where my SQL Server databases are stored. I have the mdf files on one drive and the log files on another drive on the NAS.

    An update this weekend did not work but it is now the NAS is working again and connected back to the server. I can log into the server and see the mdf and log files on their separate drives, so the data is still there along with the log files. The drive letters are the same.

    In Management studio, I can see the databases, but there is not a plus sign beside the database to expand them. I can right click on the database name go to task and most of the options are greyed out. I was hoping to do a restore, but it is greyed out. I don't think a back was done on some of the databases.

    Is there a way to reconnect the databases to the mdf files?

    Thanks!

  • September 27, 2011 at 8:50 am

    #1387218

    Delete it and re-attach?

    http://sqlvince.blogspot.com/[/url]

  • September 27, 2011 at 9:16 am

    #1387237

    When I try to delete the database I get an error that the file does not exist. The database name is showing up in the drop down list under "Databases" and the mdf and log files are there. I also tried to detach and that gave an error as well.

    The error when I tried to delete was "The Database [dbname] does not exist on the server."

  • September 27, 2011 at 9:20 am

    #1387242

    So you can see the DB in the drop down list, but you cant right click on it and see which files its pointing to?

    Have you restarted sql server service since updating the NAS? Is this an option for you?

    http://sqlvince.blogspot.com/[/url]

  • September 27, 2011 at 9:37 am

    #1387264

    I don't have the rights to restart the services, but I will have them do that. They are going to shutdown the server and the array and bring them back up. Then we can restart the services and see what happens.

    Thanks!

  • September 28, 2011 at 6:51 am

    #1387713

    Just to let you know how we got the databases back online.

    Shutting down the server and the array and bringing them back up in the proper order helped some databases, and then rest we had to restore from a tape backup of the mdf and log files.

    I could not delete or detach the databases so I was afraid I was going to use the rebuild, but we used a tape backup instead.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply