Solved

Connect a restored SQL database to SQL 2008 Express

Posted on 2014-11-12
6
245 Views
Last Modified: 2016-10-27
I have a SQL database I backed up from Acronis which I restore to a folder. I would like to connect to this database however having problems, says the file can't open the database and errors out. I'm using SQL Express database was restored from Acronis.
0
Comment
Question by:WORKS2011
  • 3
  • 3
6 Comments
 
LVL 33

Expert Comment

by:ste5an
ID: 40438270
What have you tried to attach the database*? What are the error messages*?

btw, depending on the Acronis version, you may have a corrupted database file(s),

*) Post your script and its output.
0
 
LVL 17

Author Comment

by:WORKS2011
ID: 40438343
Acronis does scare me, it's an old version of Acronis.

I go into SQL Studio Express / File / Open point to the .mdf file and get the following error:

sql error
0
 
LVL 33

Assisted Solution

by:ste5an
ste5an earned 500 total points
ID: 40438435
Wrong approach. Right click on the server node in the object explorer and choose attach database.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 17

Author Comment

by:WORKS2011
ID: 40438479
this doesn't open the .mdb file.
0
 
LVL 17

Author Comment

by:WORKS2011
ID: 40438498
actually it just did...thank you?
0
 
LVL 33

Accepted Solution

by:
ste5an earned 500 total points
ID: 40438536
Attach database
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Free HD cloner 11 61
Error Creating Foreign Keys in SQL Database 7 35
MS SQL Server Modify insert/update update to use MERGE 13 47
SSRS  - Dropdown with Null 3 25
This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
Are you looking to recover an email message or a contact you just deleted mistakenly? Or you are searching for a contact that you erased from your MS Outlook ‘Contacts’ folder and now realized that it was important.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

773 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