Re: SPS2003 SQL Database sizes?

From: Sara Windsor (SaraWindsor_at_discussions.microsoft.com)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 09:55:02 -0800

Thanks! Makes sense.
If one is using SharePoint's builtin backup/recovery tool, does anyone know
if there are any SharePoint recommendations for these settings within SQL?
Since I'm not really sure how much history I *should* keep given my setup
(medium server farm per Microsoft's Solution Accelerator for Intranets), I'm
not sure how to proceed - but it certainly doesn't seem wise to just let the
logfile sizes grow indefinitely.
TIA.

"Bil Simser [MVP]" wrote:

> 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

  • Re: Sharepoint and SQL?
    ... I understand you have removed SQL on you SBS Server, ... Companyweb to MSDE, based on my experience, you can perform the following ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ...
    (microsoft.public.windows.server.sbs)
  • RE: Problems upgrading SQL MSDE for Sharepoint
    ... I am glad to know the upgrade Sharepoint ... Microsoft CSS Online Newsgroup Support ... With this working I was able to start upgrading SQL MSDE for SharePoint. ... >white paper to backup your SBS server first. ...
    (microsoft.public.windows.server.sbs)
  • Re: sharepoint error
    ... If you are using SBS 2003 Premium Edition the easiest way is to follow ... to upgrade the SharePoint named instance. ... and search on "Migrating from WMSDE to SQL Server" ... Microsoft Small Business Server Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Upgrade of Sharepoint to SQL Server 2000 - Questions
    ... If you are using SBS 2003 Premium Edition then you could upgrade the ... SharePoint named instance to full SQL. ... enjoy Full Text Search in Sharepoint and all the advantages SQL server ...
    (microsoft.public.windows.server.sbs)
  • Having trouble getting Sharepoint over to SQL 2000 during Premium Upgrade
    ... Last week my client wanted me to upgrade a SBS standard edition to ... I ran through the html procedure to install single instance of SQL ... I then tried to upgrade Sharepoint from MSDE to SQL as per same ...
    (microsoft.public.windows.server.sbs)