RS4KEV
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\\UpdateServicesDb Files\SUSD B.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\\UpdateServicesDb Files\SUSD B_log.ldf" . Operating system error 5: "5(error not found)".
File activation failure. The physical file name "d:\WSUS\\UpdateServicesDb Files\SUSD B_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
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\\UpdateServicesDb
Msg 5120, Level 16, State 101, Line 3
Unable to open the physical file "d:\WSUS\\UpdateServicesDb
File activation failure. The physical file name "d:\WSUS\\UpdateServicesDb
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER