????? ????? ?????? BPA ?? SBS 2008 ???? ??? ??? ??? ??? ??? ????? ?????? ????? Windows SharePoint Services (???? ??? ????? ?????? ?? ? ????????).

?????? ????????? ?????? ?????????
???? ???????: 2000544 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

???????

?? ?????? ??? ??? ??? Windows SharePoint Services 3.0 (WSS 3.0) ????? ?????? ??? ???? ??????? ????????? ??Small Business Server 2008 (SBS 2008). ????? ???? ????? ???? ????????? Best Practices Analyzer (BPA) ?????? ?? SBS 2008 ???????? ?? ????? ????? ?????? ????? ???? ??? ???:

??? ??? ????? ?????? ????? Sharepoint ???? ?????? (Sharepoint Config database log file getting large)

???? ??? ??? ??? ????? ?????? ????? Windows SharePoint Services ?????? (???? ????? ???? ?? ? ????????) (The Windows SharePoint Services configuration databases log file is getting large (currently over 1gb in size))

?????

???? ??? ?? ???? ????? ????? ???????? ??? ??????? ??????? ????????? ????? ???? ????????? ?????? ?????? ??? ???? ?? ?????????? ?? ????? ????????.

????

?????? ??? ??? ?????? ???? ??????? ???????. ?? ???????? ??? ???? ???????? ????? ?? ?????? ?????.

??? ???? ?????? ??? ??? ????? ????? ???? ????? ??? ????? "????? ??????? ???????? ???". ???? ??? ???? ????? ??? ??????? ?????? ?????? ??? ????? "????? ??????? ?????".

????? ??????? ???????? ???

?????? ??? ??????? ????????? ???? ??? ???????? ????? ??? ???????. ??? ???? ???? ??? Run (?????) ?? ???? ?????? File Download (????? ???)? ????? ??????? ???????? ?? ??? ???????.

????? ??? ???????
Microsoft Fix it 50682



?????? ?? ????? ??? ??????? ?????? ?????????? ???. ??? ???? ???? ??????? ???????? ????? ?? ??????? Windows ??????? ??????.

?????? ??? ??? ?? ???? ??? ???? ????????? ???? ???? ?? ???????? ????? ??? ??????? ???????? ??? ???? ????? ????? ?? ??? ????? ??? ????? ?? ?????? ??? ???? ????????? ???? ???? ?? ???????.

????? ??? ??????? ?????

1. ?? ???? ?????? ?? ?? ???? ???? ?????? ????? ?? ???????. ???? ????? ?????? c:\logshrink.sql

declare @ConfigDB varchar(255);
declare @ConfigDBLog varchar(255);
declare @ConfigDBCmd varchar(255);
select @ConfigDB = name from sys.databases where name like 'SharePoint_Config_%';
set @ConfigDBCmd = 'BACKUP database [' + RTRIM(@ConfigDB) + '] to disk=''C:\windows\temp\before.bkf''';
execute(@ConfigDBCmd);
set @ConfigDBCmd = 'use [' + RTRIM(@COnfigDB) + ']';
execute(@ConfigDBCmd);
set @ConfigDBCmd = 'BACKUP LOG [' + RTRIM(@ConfigDB) + '] WITH TRUNCATE_ONLY';
execute(@ConfigDBCmd);
set @ConfigDBCmd = 'use [' + RTRIM(@COnfigDB) + ']';
execute(@ConfigDBCmd);
select @ConfigDBLog = name from sys.database_files where name like 'SharePoint_Config%_log';
set @ConfigDBCmd = 'use [' + RTRIM(@ConfigDB) + '] DBCC SHRINKFILE([' + RTRIM(@ConfigDB) + '_log],1)';
execute(@ConfigDBCmd);
set @ConfigDBCmd = 'BACKUP database [' + RTRIM(@ConfigDB) + '] to disk=''C:\windows\temp\after.bkf''';
execute(@ConfigDBCmd);
go

2. ?? ???? ???? ????? ??? ????? ??? ?????? ????? ??????:

sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E -i c:\logshrink.sql


??? ?? ???? ??? ???????? ????? ????? ????? ??? ??????? (before.bkf ?after.bkf) ?? C:\windows\temp.

???????

???? ???????: 2000544 - ????? ??? ??????: 04/?? ?????/1432 - ??????: 2.0
????? ???
  • Windows Small Business Server 2008 Premium
  • Windows Small Business Server 2008 Standard
????? ??????: 
KB2000544

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com