Solved

SQL 2005 recovery pending issue

Posted on 2011-03-01
4
2,048 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 45

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

The articles for turning off the Client firewall policy on the internet are for SBS 2008 and don't really help for SBS 2011. They actually moved the Client firewall policy. In 2011, the client firewall policy has moved to the SBS computers conta…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

705 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

21 Experts available now in Live!

Get 1:1 Help Now