Solved

SQL 2005 recovery pending issue

Posted on 2011-03-01
4
2,067 Views
Last Modified: 2012-05-11
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

0
Comment
Question by:RS4KEV
4 Comments
 
LVL 32

Accepted Solution

by:
ewangoya earned 167 total points
ID: 35012209
The double slash is not correct
try
Go to database properties->Files and change the path if it shows the same \\ in the Path
0
 
LVL 47

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 167 total points
ID: 35015647
Looks to me that you have problems with disk so those databases should be in suspect mode.
0
 
LVL 13

Assisted Solution

by:geek_vj
geek_vj earned 166 total points
ID: 35024369
Operating system error 5 - shows that this is an access issue.
Please ensure that the SQL Service account has got full permissions to all the SQL Server folders. (esp. the folder where the data and log files are located)
Once it is done, try restarting the SQL Services which should bring the database online.
0
 

Author Closing Comment

by:RS4KEV
ID: 35083962
Thanks for all the comments.  It seemed to a bit of all of them and ultimately was a database tape recovery
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now