1

Topic: Bases left in a state "Recovery Pending"

Day kind;
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.)".
Very strange.
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?
Thanks.

2

Re: Bases left in a state "Recovery Pending"

On files too it is right is?

3

Re: Bases left in a state "Recovery Pending"

Got out.
1) Deduced bases offline.
The code! From Management Studio it was impossible.

use master;
go
ALTER DATABASE DB_TEST SET OFFLINE WITH ROLLBACK IMMEDIATE;
go

2) Disconnected bases.
The code! From Management Studio it was impossible.

USE master;
GO
EXEC sp_detach_db @dbname = N'DB_TEST ';
GO

3) Then connected files of databases reversely and all earned.
Somehow so.

4

Re: Bases left in a state "Recovery Pending"

4) Turned gray .

5

Re: Bases left in a state "Recovery Pending"

User2155 wrote:

4) Turned gray .

Yes it is fine,  is.

6

Re: Bases left in a state "Recovery Pending"

User2155;
Something similar I watched after  fulfilled vmotion one of cluster servers. Here then I am exact hardly  did not splice, from 60 bases of more half were able Suspect. As it was clarified there is such bug at VMWare, he is not on friendly terms with disks RDM, and at performance vmotion there is a high probability to receive basis in a state suspect. Reboot  solves a problem, but it is all the same unpleasant.

7

Re: Bases left in a state "Recovery Pending"

User2155 wrote:

Got out.
The code! From Management Studio it was impossible.

Management Studio a case not 17?
Were connected far off or launched MS immediately on the server?