Re: Sharepoint transaction logs

Perhaps you should just backup your transaction logs, unless your happy to
recover to your full backups, then you should set the logging to simple.
Really its just a matter of choosing your backup/restore strategy

"Jackson" <jackson_num5@xxxxxxxxx> wrote in message
news:#GlBq01TFHA.2304@xxxxxxxxxxxxxxxxxxxxxxx
> I've been shrinking the databases for sharepoint daily and I noticed that
> the portal_Site transaction log files do not shrink. The one difference
> that I noticed was that when I goto properties and options, The recovery
> option is set to full, but when I change it to simple the transaction logs
> actually shrink.
>
> Has anybody just kept the portal_Site db recovery option to simple? Are
> there any issues with doing this over keeping the db to full?
>
> TIA,
>
> Jackson
>
>


.

Relevant Pages

  • Re: SQL 2005 Shrink issue
    ... you can't take a transaction log backup when your database in SIMPLE Recovery Model. ... shrink on the .ldf DB's in full mode? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)
  • Re: Log file size not reduce
    ... If you don't shrink it, it will eventually take up the ... > BACKUP LOG DBTest WITH TRUNCATE_ONLY ... the recovery mode to simple, and SQL Server will regularly truncate the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Transaction Log ENORMOUS!! Help
    ... If you are going to leave it in simple recovery, then you can shrink the ... Yesterday I changed backup model to SIMPLE from FULL. ... I realized the recovery model was set to FULL by our vendor, ... Transaction log is set to "automatically grow". ...
    (microsoft.public.sqlserver.server)
  • RE: MSDE Backup
    ... Would I also have to restore the transaction logs in a disaster ... transaction log can only be backed up in bulk-logged recovery mode ... Subject: MSDE Backup ...
    (microsoft.public.sqlserver.msde)
  • Re: Problem in RSG
    ... Which means that the transaction logs for 4-7 data are there. ... Yes when you restore the last backup, it will replay the log files. ... During a Dial Tone recovery I was able to restore the 4 PM data as well ...
    (microsoft.public.exchange.admin)
Quantcast