Topic: Bases left in a state "Recovery Pending"
Today rebooted MS SQL after that 2 bases left in a state "Recovery Pending" and do not want to be returned from it.
The server broad gull writes here such :
Unable to open the physical file "F:\Database_files\DATABASE_NAME.mdf". Operating system error 5: "5 (Access is denied.)".
1) the server has rights to these folders.
I checked up. On an adjacent disk with the same rights lives temp_db and anything, it is launched normally.
2) Specially created test basis on disk F (to which "there is no access").
Formed well, problems with access are not present, labels in basis too form without problems.
I.e. something not clear happens to these bases. How here it is necessary to get out? Where it is possible to dig?