Re: _SITE Database in FULL RECOVERY MODE?

Hi Wei-Dong XU,

thanks for your quick answer.

So, since it seems that is a MS requirement that the DDBB is in full
recovery mode, we'll keep this mode for the Database.

We'll try to backup and shrink the _Site DDBB. This would reduce the log
file. If I had any trouble I'd contact you again.

Thanks for your help.



"Wei-Dong XU [MSFT]" <v-wdxu@xxxxxxxxxxxxxxxxxxxx> escribió en el mensaje
news:$TzPH0k9FHA.1236@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Hi,
>
> For the large log, the recommended method is to use a large hard disk,
> this
> is the best resolution. This is because the Full Recovery Mode is very
> important for us on the sharepoint site maintainence. The Simple Recovery
> mode will not leave one point for us in time recovery. So please don't do
> that.
>
> So we could use the SQL Server "maintenance plan wizard" to create a
> scheduled transaction-log backup.
> How to apply a transaction log backup
> http://msdn.microsoft.com/library/en-us/howtosql/ht_7_backpc_7veh.asp
>
> After that, please feel free to shrink the log file.
>
> In addition, perhaps you are worrying about the unsupport issue for the
> operation on sharepoint database. For your case, these operations
> above(backup & shrink) will not push your portal into unsupport incident
> because they are not included in the unsupport actions:
> 898631 Supported and unsupported scenarios for working with custom site
> definitions and custom area definitions in Windows SharePoint Services and
> in SharePoint Portal Server 2003
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;898631
>
> 841057 Support may not be available if you modify tables or stored
> procedures in SharePoint Portal Server or Windows SharePoint Services
> databases
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;841057
>
> *please note: don't change the Full Recovery Mode to Simple Recovery Mode,
> it is very key for Sharepoint. Thanks!
>
> Please feel free to let me know if you have any further question on this
> matter.
>
> Best Regards,
> Wei-Dong XU
> Microsoft Product Support Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> It is my pleasure to be of assistance.
>


.