Solved

Connect a restored SQL database to SQL 2008 Express

Posted on 2014-11-12
6
257 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 34

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 34

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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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 34

Accepted Solution

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

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
GeoClustering  and AOG 25 52
SQL Server for XML PATH giving wrong results. 6 61
Backup and restore 6 42
SQL Query 20 25
This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
Ransomware is a growing menace to anyone using a computer or mobile device. Here are answers to some common questions about this vicious new form of malware.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

759 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