Re: .LDF files and SharePoint Portal

Hi Maria

A database in particular contains 2 files :
..MDF - > which contain data
..LDF - > which contain logs

So when you take a backup of the database, both these files constitute
one database.
I would not recommend deleting this file at any point of time to
maintain database consistency.

Regards,
Madhur

Maria wrote:
Hi,

I have some questions about .LDF files and Sharepoint. At the moment we
have SharePoint Portal 2003 and SQL Server as our backend database. I'm
not a DBA, so I am trying to get my head around this.

1. What data do .LDF files contain? I'm referring to the file that is
like this: companyName_SITE_log.LDF

2. If we backup sharepoint using a FULL Backup today, could we delete
all the data in the transaction log (LDF file) once the data is backed
up? Also, how do i know that the transactions in the log file have been
committed to the database?

3. Is it safe to delete the data in the .LDF file or will it cause
other problems?

4. If we have done a FULL backup, and after this, we have deleted a
site from the SiteDirectory in SharePoint and want to restore it, is it
possible to restore these sites if we have deleted the data in the
transaction log (LDF file)? Can we restore the site from the backup?

thanks for your help, Maria k.

.

Relevant Pages

  • Re: Sharepoint Portal Server 2003 Backup: Is it even possible?
    ... One of the books is the MS Press "Sharepoint Products and Technologies" ... What you say about the SQL server backup makes sense to me - to do it you'd ... Which I suppose is why SPSBackup write-locks the database.. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Sharepoint Portal Server 2003 Backup: Is it even possible?
    ... I wasn't looking at the locks when I used it. ... > One of the books is the MS Press "Sharepoint Products and Technologies" ... > What you say about the SQL server backup makes sense to me - to do it you'd ... > almost have to detach the database everytime you wanted to back up the site.. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: What is LOP_SHRINK_NOOP
    ... The ldf file is about 100Mb after months and never grows large. ... I add nightly backup to the system using DBCC backup. ... you need to have every transaction log backup since the last FULL Backup in order to successfully recover the database. ...
    (comp.databases.ms-sqlserver)
  • Re: Sharepoint Portal Server 2003 Backup: Is it even possible?
    ... vagueness of sharepoint backup. ... >> almost have to detach the database everytime you wanted to back up the site.. ... >> Small Business Solutions Architect ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Old question: backing-up & restoring SharePoint database?
    ... I'm still looking for an official docs from Microsoft, on how to backup & ... I just can't believe it if Microsoft ... Data Protection and recovery for Office SharePoint Server ... I'm still not sure it's for SharePoint's database, ...
    (microsoft.public.windows.server.sbs)