?
Solved

Question on Microsoft SQL -Restoring a Database

Posted on 2014-04-26
8
Medium Priority
?
286 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 35

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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 35

Accepted Solution

by:
ste5an earned 2000 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 35

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

770 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