Solved

Question on Microsoft SQL -Restoring a Database

Posted on 2014-04-26
8
282 Views
Last Modified: 2014-04-26
Hi Experts.

I have a backup of a Windows SBS 2011.  I can mount the drive and view the files.  I have an MSSQL database called My_Clients.  Outside of the existng server backup, there is no mssql  backup of this DB.  I cannot restore the server immediately.  
Can I find the physical location of this DB, copy it to another SQL instance to access the tables?  Can I restore this alone? What are your suggestions? Thank you
0
Comment
Question by:freshfordian
[X]
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
  • 5
  • 3
8 Comments
 
LVL 1

Author Comment

by:freshfordian
ID: 40024287
Additional comment: We were using SQL Express 2008.
0
 
LVL 33

Expert Comment

by:ste5an
ID: 40024494
Well, you can copy the My_Clients.mdf and My_Clients.ldf files to a new location and attach it to a new SQL Server instance. Do this in SSMS with the T-SQL method as show in the BOL article.
0
 
LVL 1

Author Comment

by:freshfordian
ID: 40024614
Forgive me. Relatively new to this. What is SSMS t-sql , BOL article? Thank you
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 33

Accepted Solution

by:
ste5an earned 500 total points
ID: 40024623
SSMS is the SQL Server Management Studio. When it's not installed with your SQL Server 2008 Express instance, then you can download and install it from: Microsoft® SQL Server® 2008 Management Studio Express.

BOL is Books Online. The online help articles on MSDN. See the link I've already posted.

T-SQL is Transact SQL, the SQL dialect used by SQL Server.
0
 
LVL 1

Author Comment

by:freshfordian
ID: 40024624
I have downloaded Microsoft SQL EXPRESS 2008  with the management tools and this is now running on my windows  7 pc. I have also copied over the mdf and ldf files as youc advised.   Am I ok thus far?
0
 
LVL 33

Expert Comment

by:ste5an
ID: 40024640
Yup. Copy the files in the default folders. This should be C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA. Then use the attach command from the linked article.
0
 
LVL 1

Author Comment

by:freshfordian
ID: 40024661
Thank you. That worked a treat. One final question. Is it possible to view records from within Management Studio?
0
 
LVL 1

Author Comment

by:freshfordian
ID: 40024694
Forget last question.  I ran a query that answers the question.  Thank you again for your help
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

733 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