2GB Limitation question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jack T. (71045.3122_No_Spam_Here_at_compuserve.com)
Date: 09/12/04

  • Next message: Dale: "Re: MSDE & SQL Server 2000" 
    Date: Sun, 12 Sep 2004 16:25:19 -0400

    Is the 2 GB limitation the combination of the .MDF and .LDF or only the
    .MDF?

    If both, can you turn off the LOG file?

    Thanks,
    Jack T.

  • Next message: Dale: "Re: MSDE & SQL Server 2000"

    Relevant Pages

    • Re: DB Size
      ... when I restore the db from same backup, the MDF and LDF are over 3.5 GB ... ... then log file will not grow. ...
      (microsoft.public.sqlserver.programming)
    • Corrupt LDF file
      ... I am looking for any tools capeable of repairing or recover data from a corrupt (LDF) log file. ... I was able to recover data from the damaged (mdf) data file however not all of the information was recovered. ... The log file is twice the size of the file and I believe the missing data is in that ldf file and was not committed to the mdf file before the hardware failure. ...
      (microsoft.public.sqlserver.tools)
    • SQL 2000 Corrupt LDF File
      ... I have a situation where my mdf and ldf files were ... I was able to recover data from the ... damaged (mdf) data file however not all of the information was recovered. ... The log file is twice the size of the file and I believe the ...
      (microsoft.public.sqlserver.tools)
    • Re: Actively used db, but really old LDF file date. Why?
      ... users hitting it with hundreds of CRUD transactions per day have a LDF ... the COTS product does, closing out the books, etc..). ... All db's have full daily backups and also hourly log file backups. ...
      (microsoft.public.sqlserver)
    • Re: .mdf file
      ... MDF - Primary data file ... LDF - Transaction log file ... Server uses the transaction log of each database to recover transactions. ...
      (microsoft.public.sqlserver.server)