Solved

SQL 2005 recovery pending issue

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

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SBS 2003 RWW Login 3 42
Downgrading MS SQL 2008 R2 Enterprise to MS SQL 2005 Standard? 12 64
SQL Error - Query 6 41
Cannot boot from BackupAssist recovery disc 8 43
Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

839 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