Re: _SITE Database in FULL RECOVERY MODE?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

And, of course, we don't backup the TS Logs since we don't use them (I think
that if we backuped them, they would shrink).


<cuentanewslabogel@xxxxxxxxxxxxx> escribió en el mensaje
news:uvky2ha9FHA.632@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
>
> I was experiencing some hard drive space issues, and I saw that our
> Sharepoint portal server 2003 (in Win2003 with SQL Server 2000) has its
> _Site database configured as 'full recovery mode'.
>
> This is a problem, since then the ..log.ldf file grows and grows (now it
> takes 8 gigabytes for a 2 gigabytes ddbb).
>
> Our backup strategy with Sharepoint is that we use the Veritas Backup exec
> agent, that takes care of all the databases by itself. Backup takes place
> at night, and for us it's ok to have just this late night backup, so we
> don't really need logs to restore to a certain point.
>
> I wonder if it's possible to put the database in simple recovery mode, so
> the logs just takes no space at all in our storage system.
>
>
> Thanks in advance for your answer.
>
>
>


.

Relevant Pages

  • Re: Error in Exchange
    ... Will you provide me some linkes to get more info about the role these logs ... play in .edb file or with database and how information is saved into .edb ... > backup on Sept 8. ... > transaction logs are saved in that backup. ...
    (microsoft.public.exchange.admin)
  • Re: Backups, Logs, Databases.. Logs written when? Serious Problem
    ... my concern is that my database spindles are on a raid 5 and I only have ... > 20 gig worth of transaction logs. ... > When I perform a full backup these logs need to get written to the databases ... If I run a full backup server will shut down? ...
    (microsoft.public.exchange.admin)
  • Re: corrupt database eseutil
    ... I have checked the event logs, ... RSM was stopped at the time the backup fails. ... only after i run a successful backup that the database corrupts so it does ... a repair on the database. ...
    (microsoft.public.exchange.admin)
  • Re: Does NTBackup backup SQL Express?
    ... This depends upon the configured database model. ... as I know enough that the logs must be flushed during every full backup. ... and the SBS server I regularly use runs MySQL not SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: BCVs on a cluster
    ... it cannot be used as part of a normal backup ... but you cannot apply logs to it. ... It is the same thing as a backed up database. ... I have never used BCV as the starting point for a chain of log restores. ...
    (microsoft.public.sqlserver.clustering)