Avatar of hongedit
hongedit
Flag for United Kingdom of Great Britain and Northern Ireland asked on

Errors trying to restore a SQL Database

Using Backup Exec 2010.

Backup Exec and the SQL server are both on the same server.

After a partial server disaster I had to uninstall SQL Server 2005 without being able to perform a proper SQL Backup.

I do however have a valid backup from not that long ago on BE.

I have installed a fresh copy of SQL Server 2008 R2 (free).

When I try to restore I get either one of two errors:

With redirection (Put in the local host name, default instance name and the blank database name)

Final error: 0xe000848c - Unable to attach to a resource.  Make sure that all selected resources exist and are online, and then try again.  If the server or resource no longer exists, remove it from the selection list. Edit the selection list properties, click the View Selection Details tab, and then remove the resource.
Final error category: Resource Errors

Straight restore without selecting any redirection:

An error occurred on a query to database IRIS.
V-79-65323-5133 - Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\IRIS.mdf" failed with the operating system error 5(failed to retrieve text for this error. Reason: 1815).
Storage SoftwareMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
hongedit

8/22/2022 - Mon
David Todd

Hi,

The reason for the second error is at first glance quite simple - that directory no longer exists. It is the SQL 2005 directory, and SQL 2008 changed how it names directories and would have at any rate on an existing server installed to another directory.

That is, do check all your paths ... can't guarantee that they will be the same, even if you had reinstalled SQL 2005.

Regards
  David
hongedit

ASKER
Hi

Hmm, that kind of makes sense.

I do still have the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA path which I can browse to on explorer.

However, when I tried to just attach the DB from Management Studio, I could not browse further than C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\

Any suggestions? I just need this DB mounted.
David Todd

Hi,

Sounds like might be a permissions issue or corruption on that part of the path.

Sounds like a new server or complete rebuild is in the cards if it doesn't come right quickly.

Can you browse that path using explorer (say) and see the mdf and ldf files?

Regards
 David
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
hongedit

ASKER
I can see the files via explorer, but I am unable to browse that far from Management Studio.

Can I not restore to another path?
ASKER CERTIFIED SOLUTION
David Todd

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
hongedit

ASKER
Ok.

I selected to restore to D: drive and to keep the database offline.

It restored and I opened Management Studio to try and attach it.

Lo and behold, its already in there with (Restoring...) next to it.

Fingers crossed!