Solved

sql 2008 management studio

Posted on 2014-03-03
3
207 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

863 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

19 Experts available now in Live!

Get 1:1 Help Now