Solved

Question on Microsoft SQL -Restoring a Database

Posted on 2014-04-26
8
276 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
  • 5
  • 3
8 Comments
 
LVL 1

Author Comment

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

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
 
LVL 32

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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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 32

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
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.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now