Solved

sql 2008 management studio

Posted on 2014-03-03
3
218 Views
Last Modified: 2014-03-29
i found the database i need to export. i did a backup and now i need to find the target files, how do i go about finding this ? the tech was talking about pointers....
0
Comment
Question by:ttrbrtsn
[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
3 Comments
 
LVL 22

Expert Comment

by:plusone3055
ID: 39901455
what target files are you referring to ? can you be a little more specific :)


heres a tutorial with pictures on how to export a database from SQL Server 2008  it might answer your question. if not please elaborate on "target files"  

http://www.mssqltips.com/sqlservertutorial/202/simple-way-to-export-data-from-sql-server/
0
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 39901495
from ssms, riht click on the server -> properties -> Database settings
check the value of 'Backup'  you will be able to see the default backup location
or
try this script http://blog.sqlauthority.com/2010/11/10/sql-server-get-database-backup-history-for-a-single-database/

or you can create another backup by running the following tatement

BACKUP database yourDBName to disk = 'c:\yourDB.bak'
0
 
LVL 35

Expert Comment

by:David Todd
ID: 39901759
Hi,

I suggest that the quickest way is to start a backup again, and click the link for the backup file name, and see which directory that is in.

If SQL is installed with defaults, then look at
C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008R2\MSSQL\Backup

Note that the name of my instance is SQL2008R2, so that folder could be something different on your machine.

HTH
  David
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

717 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