Re: SPS2003 SQL Database sizes?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bil Simser [MVP] (bsimser_at_shaw.ca)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 17:44:05 +0000

Sara,

The LDF files are log files and used for restoring the transactions in
SQL. If you're doing file level backup on SharePoint or using some other
tool for restoring SharePoint then you probably don't need them. If
you're using them for restore purposes, it's a SQL setting to determine
how often they roll over or how big they grow. By default (I think) they
just keep growing until you manually remove them. You'll need to
determine how much history to keep that works for your setup and
configure it in SQL Server. 

--
Bil Simser
http://weblogs.asp.net
"Sara Windsor" <SaraWindsor@discussions.microsoft.com> wrote in message 
news:SaraWindsor@discussions.microsoft.com:
> As my number of SPS2003 clients increases, of course the size of the
> databases (especially _SITE) is growing in leaps & bounds. I've noticed
> that
> the SQL database LDF files (which I think are the logfiles?) are now much
>
> larger than the MDF files (which I think are the primary database files?).
>
> I'm running successful backups via SPS's builting backup/restore tool...
> and
> SQL logs the successful backups... but the LDF files remain huge. Assuming
>
> that the LDF files are the logfiles - do they ever get purged during
> backups?
> or do they just continue to grow with the database?
> TIA.

Relevant Pages

  • SPS2003 SQL Database sizes?
    ... larger than the MDF files (which I think are the primary database files?). ... I'm running successful backups via SPS's builting backup/restore tool... ... SQL logs the successful backups... ... but the LDF files remain huge. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Stupid mistake ...
    ... Backup all the mdf and ldf files in \Program Files\Microsoft SQL ... You should be able to reinstall SQL, and re-attach these files, with nothing ... > Needless to say this pretty much whacked the server (yeah, ...
    (microsoft.public.sqlserver.server)
  • Hard drive crashed but MDF/LDF on drive D:
    ... the MDF and LDF files were on drive D: ... SQL 7.0 installed on it...is there a way to "attach" to ... or are they lost? ...
    (microsoft.public.sqlserver.server)
  • Re: Fragmented tempdb
    ... the same Raid 5 D:\ drive as the main database mdf and ldf files. ... main database mdf is about 7 Gb and its ldf is about 5.5 Gb. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.server)
  • Re: Hard drive crashed but MDF/LDF on drive D:
    ... with SQL7 and/or SQL 2000 ... > the MDF and LDF files were on drive D: ...
    (microsoft.public.sqlserver.server)