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

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

?? ????? ??

?????

Microsoft SQL Server 2008, ???syspolicy_purge_history?? ?? SQL Server ????? ????? ???? ?? ???? ??syspolicy_purge_history??? ????? ??????? ?? ????? ????? ?? ??? ?????? ??? ????? ??? ????? ?? ???? ?? ?????? ????? ??????? ?? ???? ??syspolicy_purge_history????? ????:
???????????????:
????? ?? ?????? (syspolicy_purge_history) ?? ??? ??

??? ID 3
?????SQLVirtualName\instancename
????? ??? syspolicy_purge_history
??? ??? ?????? Phantom ?????? ????????? ???????
???? 00: 00: 33
SQL Severity 0
0 SQL ????? ID
Emailed ??????
?????? ??? ???? ???
?????????? ??????
??????????? 0 ?? ?????? ???? ???

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

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

SQL ????? 2005 ?? ?????? ?? ??? ??, ?? ?? ?????? ???? ?? ?? ??????? ???????? ?? ??????? SQL ????? ???? ?????? ??????? ?? ?????? ???? ?? ???? ?? ???? ??? (???????: ?????? ???????, ?????? ?? ???: 40 - SQL ????? ?? ??? ??????? ???? ??? ???)] ????? ?? ?????? ???? ??? ???? ???SQLVirtualName\instancename. ????? ?? ??????? ??????? ???? ??? ??? ?????? ??????? ???? SQL ????? 2005 ?? ?????? ?? ??? ??, ?? ?? ?????? ???? ?? ?? ??????? ???????? ?? ??????? SQL ????? ???? ?????? ??????? ?? ?????? ???? ?? ???? ?? ???? ??? (???????: ?????? ???????, ?????? ?? ???: 40 - SQL ????? ?? ??? ??????? ???? ??? ???) '

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

????

??? ?? ?????? ?? ????syspolicy_purge_history??????? ??????? ?? ??? ??????? ????? ??? ?? ????? ?? ????? ???????? ??? ??? ?? ????? ???? ???

????????

?? ?????? ?? ?? ???? ?? ???, ????? ??? ?? ???? ?? ???? ????:.

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

?? ??? 3 ?? ??????? ????syspolicy_purge_history?????? ??? ???? ?? ???, ????? ????? ?? ???? ????::
  1. SQL ????? ??????? Studio ??????? ?????
  2. ??????? ????SQL ????? ?????, ?? ???? ??? ??????? ?????????.
  3. ????-????? ????syspolicy_purge_history?? ????-????? ????, ?? ???? ??????.
  4. ????? ????,???.
  5. ????? ????,?????? ????????? ?????? Phantom ???????? ????-????? ????, ?? ???? ?????????.
  6. ?????????????? ???, ???????? ??? ??? ??????? ??????? ?? ??? ??????? ????? ??? ?? ????? ???? ???????????? ?????
  7. ????? ????,OK?? ????-????? ????, ?? ???? ?????? ????.

???? 2: Re-create syspolicy_purge_history ?????

Re-create ???? ?? ???syspolicy_purge_history?????, Transact 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 ?????, ????? ????????? ??????? ???????? ??? ?? ??? ??????? ?????? ?? ???????? ??? ?? ??? ????? ????????? ???????, ??????? ????? ??????? ?? ??????? ???? ??? ?????, ??????? ????? ?? ???? ??????? ??? ???????? ?? ??? ?????

???

???? ID: 955726 - ????? ???????: 06 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Developer
??????: 
sql2008relnotetools sql2008relnote kberrmsg kbtshoot kbprb kbmt KB955726 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??: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