SitePoint Sponsor

User Tag List

Results 1 to 6 of 6

Hybrid View

  1. #1
    SitePoint Zealot eStudio's Avatar
    Join Date
    Dec 2001
    Location
    NE Texas
    Posts
    153
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to find SQL db on hard drive?

    I'm new to SQL and not sure how to find the db file on a hard drive (ie: to find a .jpg you do a search for *.jpg)??? Or is this possible with a SQL db?

    Any help appreciated.

    TIA,
    Donna

  2. #2
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,294
    Mentioned
    123 Post(s)
    Tagged
    1 Thread(s)
    SQL Server or Access? Makes a big difference...
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style
    Learn how to be ready for The Forums' Move to Discourse

  3. #3
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    If it's SQL Server, it's not flat-file based (*.mdb or something). You need to access the database via Enterprise Manager or a similar application.
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  4. #4
    SitePoint Zealot eStudio's Avatar
    Join Date
    Dec 2001
    Location
    NE Texas
    Posts
    153
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SQL Server

  5. #5
    Sultan of Ping jofa's Avatar
    Join Date
    Mar 2002
    Location
    SvÝ■jˇ­
    Posts
    4,080
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Access: *.mdb (sample databases in C:\Program Files\Microsoft Office\Office\Samples)
    Sql server: *.mdf, *.ldf (usually located in C:\Program Files\Microsoft SQL Server\MSSQL\Data)
    Mysql: *.myd, *.myi (usually located where you installed the product)

    Anyhow, the path to the db file is only relevant in the Access case, with MsSql/MySql you connect to the database server, not the data file

  6. #6
    SitePoint Member
    Join Date
    Dec 2001
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Assuming you are referring to MS SQL Server and a typical install, the files are located in program files\Microsoft SQL Server\MSSQL\DATA as MDF files, along with associated LDF log files.

    CAUTION!!! Do not simply move them etc., because SQL Server will then not be able to find them. Use the tools within SQL Server if you need to do anything with the files.
    You may want to look in the online help to read about detaching/attaching DB files (ie using sp_detach_db).

    Good luck.

    Bill
    BLNye@att.net
    (temporarily borrowing Ideaguy's login after he showed me this site)


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •