Link to home
Start Free TrialLog in
Avatar of RS4KEV
RS4KEVFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL 2005 recovery pending issue

Hi experts

SQL 2005, following an MS update i seem to have a number of DB in recovery pending situation.  

Using command

select name, state_desc from sys.databases

I've identified them and then tried running

ALTER DATABASE SUSDB SET ONLINE

which reponds with
(13 row(s) affected)
Msg 5120, Level 16, State 101, Line 3
Unable to open the physical file "d:\WSUS\\UpdateServicesDbFiles\SUSDB.mdf". Operating system error 5: "5(error not found)".
Msg 5120, Level 16, State 101, Line 3
Unable to open the physical file "d:\WSUS\\UpdateServicesDbFiles\SUSDB_log.ldf". Operating system error 5: "5(error not found)".
File activation failure. The physical file name "d:\WSUS\\UpdateServicesDbFiles\SUSDB_log.ldf" may be incorrect.
Msg 945, Level 14, State 2, Line 3
Database 'SUSDB' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.
Msg 5069, Level 16, State 1, Line 3
ALTER DATABASE statement failed.

Not being an SQL expert, i've looked at the files it's calling.  They are there and permissions appear to be correct.  Is the double \\ correct in the path?

TIA

Kev

ASKER CERTIFIED SOLUTION
Avatar of Ephraim Wangoya
Ephraim Wangoya
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RS4KEV

ASKER

Thanks for all the comments.  It seemed to a bit of all of them and ultimately was a database tape recovery