Solved

Connect a restored SQL database to SQL 2008 Express

Posted on 2014-11-12
6
242 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
Is your company's data protection keeping pace with virtualization? Here are 7 dynamic ways to adapt to rapid breakthroughs in technology.
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…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

863 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

20 Experts available now in Live!

Get 1:1 Help Now