Re: 2GB Limitation question

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

From: Stephen Dybing [MSFT] (stephd_at_online.microsoft.com)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 12:26:31 -0700

Uh no, the log file size does not factor into that 2GB database limitation.
When the rows are deleted from your table, they are gone and new rows can
use that space. SHRINK is still not necessary for this situation and if
performance is an issue, please remember that shrinking and growing the file
is expensive. It's possible that SHRINK is necessary in some situations for
some people, but I think it's highly overrated. 

-- 
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Yeo" <RichardYeo@discussions.microsoft.com> wrote in message 
news:55CC05A1-238C-4FB3-A117-466C3A6F0570@microsoft.com...
> So SHRINK is important ;)
> Sorry just pulling Stephens leg I knew this all along.
> MSDE is often used as a log and therefore lots of deletes will be used 
> when
> the old log information is no longer required. Therefore shrink is 
> important.
>
> Don't forget to backup your transaction logs regularly to prevent them
> growing continuously.
>
> You should also consider running an integrity check regularly.
>
> Rich
>
> "Jack T." wrote:
>
>> 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.
>>
>>
>>

Relevant Pages

  • Re: dbcc reindex & dbcc shrinkdatabase?
    ... An increase in the data file is acceptable but not the log file. ... started testing out is scheduling the "dbcc reindex", ... not much free space to reclaim. ... this does indeed shrink the virtual logs size, ...
    (microsoft.public.sqlserver.server)
  • Re: Database/Logs dont shrink with Maintenance Task
    ... Only a shrink file can do that but it may require a backup to get ... Other wise it has to keep growing to make room for more transactions. ... the log file smaller--whether you shrink or not? ...
    (microsoft.public.sqlserver.setup)
  • Re: More Information
    ... followed by a Shrink, the log file went down to 32MB. ... Dr. Doug Pruiett ... full, a log backup needs to be done, in simple a basic db backup needs to be ...
    (microsoft.public.sqlserver.server)
  • Re: Cant shrink log file
    ... model and don't do log backup. ... Either schedule regular log backups or set recovery model to simple. ... I was trying both and still it doesn't shrink. ... Cannot shrink log file 2 because the logical log file located at the end of the file ...
    (microsoft.public.sqlserver.server)
  • Re: Huge Transaction Log
    ... http://www.nigelrivett.net/TransactionLogFileGrows_1.html Log File issues ... http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File ... http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)