?
Solved

Question on Microsoft SQL -Restoring a Database

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

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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 36

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 36

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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

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…
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 …
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

621 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