i would to install sql server 2008 + studio manager and attach to it MDF file that i have

Posted on 2013-12-01
Medium Priority
Last Modified: 2013-12-06
can you please advice step how do i do that and from which website i can install those?

Question by:gvilbis
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

Author Comment

ID: 39689240
one more things i would like to install it on Virtual machine if its mater?
LVL 20

Expert Comment

ID: 39689261
You can install "Microsoft® SQL Server® 2012 Express" which is free and includes the Management Console. You can download it from here. Once downloaded, install it (you can use a VM). Once installed, simply run the Management and select the "Attach" option.

Accepted Solution

QuinnDex earned 1002 total points
ID: 39689285
the MDF that you have do you know what version of SQL it was created in, 2008 or 2008 r2

if it was the 2008 then you will not be able to attach it to a later versions of SQL and will have  to install SQL Server 2008 express
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  


Author Comment

ID: 39689290
the sql mdf was in SQL server 2000
can you please send me link to install sql server 2008 express


Assisted Solution

QuinnDex earned 1002 total points
ID: 39689303
i dont know 2000 too well i got into SQL with 2005 you may have problems attaching a 2000 MDF to anything later as i know there was big changes with 2005

here is the sql 2000 express equivalent i think that would be your best first step

LVL 11

Assisted Solution

HuaMinChen earned 498 total points
ID: 39689314

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

752 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