?
Solved

Connect a restored SQL database to SQL 2008 Express

Posted on 2014-11-12
6
Medium Priority
?
264 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 36

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 36

Assisted Solution

by:ste5an
ste5an earned 2000 total points
ID: 40438435
Wrong approach. Right click on the server node in the object explorer and choose attach database.
0
 
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 36

Accepted Solution

by:
ste5an earned 2000 total points
ID: 40438536
Attach database
0
Question has a verified solution.

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

The recent Petya-like ransomware attack served a big blow to hundreds of banks, corporations and government offices The Acronis blog takes a closer look at this damaging worm to see what’s behind it – and offers up tips on how you can safeguard your…
Dropbox has a relatively new feature called Smart Sync.  This feature allows Dropbox Professional (not plus) and Dropbox Business (if enabled) users to store information in Dropbox WITHOUT storing any files on their computer.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
Suggested Courses

569 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