[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!


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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
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…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

656 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