473,837 Members | 1,619 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Use MS SQL Server 2005 Developer version to open MDF file?

Tim
Hello,
We do not run SQL Server in our shop, but I'm starting to be tasked with
analyzing SQL Server databases from outside shops. I will need to
open .MDF files sent to me. Can I do this using SQL Server 2005
Developer version? Or do we have to spring for the Workgroup version?
Thanks, in advance, for your help.
T
Mar 1 '06 #1
3 22895
Tim (tp***@cornell. edu) writes:
We do not run SQL Server in our shop, but I'm starting to be tasked with
analyzing SQL Server databases from outside shops. I will need to
open .MDF files sent to me. Can I do this using SQL Server 2005
Developer version? Or do we have to spring for the Workgroup version?


You don't really open an MDF file, but rather you attach it SQL Server,
which will open it, and then you can query it from a query tool.

You can use any edition of SQL Server 2005 for this.

However, you should also request to get the LDF file, the transaction
log, as it may be difficult to attach the MDF file alone.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Mar 1 '06 #2
Hi Tim

Why don't you ask them to run a backup of the database(s) in question to a
file and then restore the databases on your end. If the SQL Server 2005
developer version has a Enterprise Manager this is pretty easy to do. If not
read Books Online about the Restore Command.

BTW I don't know if you can attach an MDF that hasn't been previously
detached (using sp_detach_db). Your customers almost certainly won't want to
detach their open databases just to send them to you, whereas a full backup
can be run on a open database. I suspect just doing a Copy of an open MDF
may give you a file you can't use in any way.

See books online about sp_attach_db and sp_detach_db and my favorite
sp_attach_singl e_file_db (which attaches an MDF without needing the LDF).

For Example:

EXEC sp_attach_singl e_file_db @dbname = 'pubs',
@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Da ta\pubs.mdf'

You might try this with the file(s) you have and see if if works.

--
-Dick Christoph
"Tim" <tp***@cornell. edu> wrote in message
news:du******** **@ruby.cit.cor nell.edu...
Hello,
We do not run SQL Server in our shop, but I'm starting to be tasked with
analyzing SQL Server databases from outside shops. I will need to open
.MDF files sent to me. Can I do this using SQL Server 2005 Developer
version? Or do we have to spring for the Workgroup version?
Thanks, in advance, for your help.
T

Mar 2 '06 #3
Tim
Thanks for the assistance! It's been very helpful.
Tim

DickChristoph wrote:
Hi Tim

Why don't you ask them to run a backup of the database(s) in question to a
file and then restore the databases on your end. If the SQL Server 2005
developer version has a Enterprise Manager this is pretty easy to do. If not
read Books Online about the Restore Command.

BTW I don't know if you can attach an MDF that hasn't been previously
detached (using sp_detach_db). Your customers almost certainly won't want to
detach their open databases just to send them to you, whereas a full backup
can be run on a open database. I suspect just doing a Copy of an open MDF
may give you a file you can't use in any way.

See books online about sp_attach_db and sp_detach_db and my favorite
sp_attach_singl e_file_db (which attaches an MDF without needing the LDF).

For Example:

EXEC sp_attach_singl e_file_db @dbname = 'pubs',
@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Da ta\pubs.mdf'

You might try this with the file(s) you have and see if if works.

Mar 8 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
647
by: Steve Buster | last post by:
All right, I have read every forum, newsgroup etc about this issue and no one seems to know how to fix it. I am getting a "Server Application Unavailable" exception running my .NET 1.1 application. I use W2K SP4 and have applied the hot Fix KB824146 and KB824105, both IE fixes. I don't have VS installed because this is a Quality Environment. I do have .NET SDK and .NET 1.1 Runtime installed. I can't change my APSNET user to run as...
10
1462
by: Rob G | last post by:
Hello, I've seen bits and pieces of this problem, on the newsgroups, but I haven't been able to get it exactly how it happened to me... I've been using Visual Studio and learning ASP.NET with no problems. IIS is working and everything was just fine. Then my company did some Microsoft updates (I wish I knew exactly which ones) on my machine and now when I try to open any of the pages I built, I
9
4977
by: Neil | last post by:
We have an Access 2000 MDB with a SQL 7 back end. We are upgrading SQL Server to SQL 2005, and are considering upgrading to Access 2003. Someone mentioned that they had heard about some incompatibilities between Access 2003 and SQL Server 2005. Anyone hear of anything? And, if so, would staying with Access 2000 be better? Thanks! Neil
4
2399
by: Skc | last post by:
We have a developer who has made an application in Visual Studio 2003 and this will not work in our version of Visual Studio 2002. Error message: Solution file loading error: The selected file is not a valid Visual Studio Solution file. When we try to load a project file, we get: Unable to read the project file. The project was created with a newer
5
2924
by: B1ackwater | last post by:
We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a front end to SQL server if we ever needed to go that route. But - is there a client/server version of Access ? Looking on the CDW site there is a bewildering variety of packages and licences and such, but we can't figure out just which do...
14
3050
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can anyone please help me with this as I want to install SQL server and also wouold be grateful, if you can suggest me any workaround to dealwith this problem.(Like should I install any new OS etc). Any help would be appreciated.
5
14437
by: Glen Buell | last post by:
Hi all, I have a major problem with my ASP.NET website and it's SQL Server 2005 Express database, and I'm wondering if anyone could help me out with it. This site is on a webhost (WebHost4Life) and was running fine and dandy, until I decided I needed to add some additional stored procedures to the database.
1
2597
by: =?Utf-8?B?Rmxhbm1hbg==?= | last post by:
I have a tutorial I was working on with Visual Web Developer 2005 express. Very basic stuff intro to asp.net. All was working fine a few days ago. I took my pc home and installed the visual studion 2005 sdk and also visual web developer 2008. Today when I try to run or debug a very basic page I am getting the error" Unable to connect to Visual Studio's Locahost Web server" I get a similar error when trying to run/debug the same project in...
0
9830
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10562
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10615
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9390
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7803
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6989
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5664
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
4036
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3122
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.