Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    6

    Unanswered: MDF file now a .dat file???

    OS:Win2000
    MSSQL:2000

    I have a database called ECS_DB, so I should have a mdf file called ECS_DB_Data.MDF and a ldf file called ECS_DB_Log.ldf. But what I have is a ECS_Data.dat file and a ECS_Log.dat file. I'm a little confused as to how this happend. Can anyone give me a clue??

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    While creating a database , it is possible for the sysadmin to specify different file names other than the default.
    Code:
    CREATE DATABASE dbforumstest 
    ON
    PRIMARY ( NAME = Arch1,
          FILENAME = 'c:\dbforumstestdata.dat',
          SIZE = 1MB,
          MAXSIZE = 200,
          FILEGROWTH = 20) LOG ON 
    ( NAME = Archlog1,
       FILENAME = 'c:\dbforumstestlog.dat',
       SIZE = 1MB,
       MAXSIZE = 200,
       FILEGROWTH = 20)
    
    exec sp_helpdb dbforumstest
    
    drop database dbforumstest
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    6
    Thank you

  4. #4
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    the file extensions have no bearing on the workin's of the log or the db and you could leave them exactly the way they are and have no problems.

    but, if you really wanted to make things right in the worlld
    you could

    sp_detachdb
    change file extensions on the actual files
    sp_attachdb

Posting Permissions

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