?????? ??? ???? ???? ???? SQL syspolicy_purge_history ?? SQL Server 2008

?????? ????????? ?????? ?????????
???? ???????: 955726 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

?? Microsoft SQL Server 2008 ?? ???? ???? ???? ???? SQL syspolicy_purge_history ??? ????? ???? syspolicy_purge_history ??? ???? ?????? ????????. ?? ????? ????? ??? ?????? ??? ??? ?? ??? ??? ??????? ?????? syspolicy_purge_history:
??????? datetime
????? "??????? ??????" (syspolicy_purge_history)

???? ?????? 3
???? SQLVirtualName \ instancename
??? ?????? syspolicy_purge_history
?????? ??? ??? ????? ?????? ???????? ???????.
??? 00: 00: 33
??????? Sql 0
???? ????? Sql 0
???? ??????? Emailed
???? ????? Net ?????
???? ??????? ??????
???? ????? ????????? 0

?????
????? ????????: user. ???????? ????? ???? ?????? ??????? ???????. ?? ??? ??????? ????? ???????? ?????: ???? ???? ???? ??? ?? ??? 1 ?? ???????? ??? PowerShell. ?? ??? ??????? '(Get-Item SQLSERVER:\SQLPolicy\SQLVirtualName\instancename).EraseSystemHealthPhantomRecords() '.

?? ?????? ???????? ????? ?? ????? ????? ??????. ??????? ??? ?? ?????? ?????? PowerShell: ' SQL Server PowerShell ???? ???: ???? ??????? ??? ' SQLVirtualName \ instancename '. [??? ??????? ????? SQLVirtualName \ instancename.--> ??? ??? ????? ????? ????? ???????.

??? ??????? ?? SQL Server 2005? ?? ???? ??? ????? ?????? ????? ?? ??? ????????? ?????????? SQL Server ?? ???? ?????? ????????? ???????. (provider: Named Pipes Provider, error: 40-Could not open a connection to SQL Server)] ??? ??????? ????? SQLVirtualName \ instancename. ??? ??? ????? ????? ????? ???????. ??? ??????? ?? SQL Server 2005? ?? ???? ??? ????? ?????? ????? ?? ??? ????????? ?????????? SQL Server ?? ???? ?????? ????????? ???????. (??????: ???? "???? ??????" ???: 40 - ???? ??? ????? SQL Server) '

???? ???? ???? ??? ?? ??? 1 ?? ???????? ??? PowerShell. ?? ??? ??????? '(Get-Item SQLSERVER:\SQLPolicy\SQLVirtualName\instancename).EraseSystemHealthPhantomRecords() '. ?? ?????? ???????? ????? ?? ????? ????? ??????. ??????? ??? ?? ?????? ?????? PowerShell: '?? ???? ?????? ??? ??????' SQLSERVER:\SQLPolicy\ SQLVirtualName \ instancename ' ???? ??? ?????. ' ???? ???? ???? ??? ?? ??? 1 ?? ???????? ??? PowerShell. ?? ??? ??????? '(Get-Item SQLSERVER:\SQLPolicy\SQLVirtualName\instancename).EraseSystemHealthPhantomRecords() '. ?? ?????? ???????? ????? ?? ????? ????? ??????. ??????? ??? ?? ?????? ?????? PowerShell: ' ?? ???? ??????? ????? ??? ????? ??? ?????. '. ??? ??????? ?????-1. ??? ??????.

?????

?? ???? ??? ??????? ?? ???? ??????? ???? syspolicy_purge_history ??? ???? ????????? ????? ?? ??? ?????? ??????? ???? ???? ????????.

????

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

??????? 1: ????? ???? syspolicy_purge_history

????? ?????? 3 ?? ?????? syspolicy_purge_history. ?????? ????? ???? ??????? ???????:
  1. ??? ????? Studio ????? ???? SQL.
  2. ?? ?????? ???? ???? SQL ?? ?? ?????? ??????.
  3. ???? ??? ?????? ?????? ??? syspolicy_purge_history ??? ?? ???? ??? ?????.
  4. ???? ??? ?????.
  5. ???? ??? ??? ??????? ????? ?????? ???????? ?? ???? ??? ?????.
  6. ?? ?????? ??? ??????? ??? ???? ????????? ???????? ??? ?????? ??????? ???? ???? ????????.
  7. ???? ??? ????? ?? ???? ??? ?????.

??????? 2: ????? ????? ???? syspolicy_purge_history

?????? ???? syspolicy_purge_history ????? ??????? SQL ???????? ???????.
DECLARE @jobId uniqueidentifier

-- Obtain the current job identifier that is associated with the PurgeHistory
SELECT @jobId = CAST(current_value AS uniqueidentifier)
FROM msdb.dbo.syspolicy_configuration_internal
WHERE name = N'PurgeHistoryJobGuid'

-- Delete the job identifier association in the syspolicy configuration

DELETE FROM msdb.dbo.syspolicy_configuration_internal
WHERE name = N'PurgeHistoryJobGuid'

-- Delete the offending job
EXEC msdb.dbo.sp_delete_job @job_id = @jobId

-- Re-create the job and its association in the syspolicy configuration table
EXEC msdb.dbo.sp_syspolicy_create_purge_job

??????? ????

?? SQL Server 2008 ???????? ?????? ???????? ????? ????? ???? ????? ???????? ??? ?????????. ????? ???? ???????? ????? ????? ?????????? ?? ??? ?????????, ?? ????? ???? ????? ?????? ??????. ????? ???? ????? ?????? ????? ??? ????????? ????? ?? ??? ??????.

???????

???? ???????: 955726 - ????? ??? ??????: 22/???? ?????/1430 - ??????: 2.0
????? ???
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Developer
????? ??????: 
kbmt sql2008relnotetools sql2008relnote kberrmsg kbtshoot kbprb KB955726 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????955726

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

 

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