Post reply

MSDE Database has an MDF named datafile AND a log file with MDF extension!

  • May 13, 2009 at 12:14 pm

    #95205

    After receiving a message that the system "Could not allocate space for object 'CA_Profile' in database 'TEST' because the 'PRIMARY' filegroup is full, we looked at the data and ldf files to see what size they were.

    The data file has an MDF extension but the log file associated with it also has an MDF extension!!!

    It's an MSDE system with the data file being at 1,913,920 KB and the log file at 1,024 KB.

    Could it have hit the 2 gigabyte limit and somehow changed the LDF file to be MDF?

    Thank you.

    Roger

  • May 13, 2009 at 3:02 pm

    #994120

    Roger Abram (5/13/2009)

    The data file has an MDF extension but the log file associated with it also has an MDF extension!!!

    Doesn't matter. The extension doesn't set the type of the file. I can create a database with a primary data file called data.doc and a log file called log.mp3. SQL doesn't care.

    CREATE DATABASE DumbFileNames ON PRIMARY

    ( NAME = N'data', FILENAME = N'D:\Develop\Databases\data.doc' )

    LOG ON

    ( NAME = N'log', FILENAME = N'D:\Develop\Databases\log.mp3')

    GO

    It's an MSDE system with the data file being at 1,913,920 KB and the log file at 1,024 KB.

    Autogrow? Is there a max file size set? If the disk out of space?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 13, 2009 at 3:10 pm

    #994128

    Thank you for your response. We deleted some records out of the database to be able to get back into it... it had hit the MSDE 2 gig limit. We'll need to do some more cleaning up or move to SQL Standard.

    Rog

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply