SQL ????? ?? ??? ???????? ?? ????? ?? ??? ????????? ?????????? ?? ????? ?? ??? ?????????????

???? ?????? ???? ??????
???? ID: 309422 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

?? ???? ?? ???? ??????? ??? SQL Server ??? ??? ???????? ?? ????? ?? ??? ????????? ?????????? ??? ?????? ?? ???? ??? ??? ???? ?? ??? ??????? ????????????? ?? ?????? ????? ???

???? ???????

Microsoft ?????? ???? ?? ?? ???-??? assess ???? ??????? ??? SQL ????? ?? ??? ?? ?? ???????? ???????? ?? ??? ??????? ????? ?? ?? ?? ?? ?? SQL ????? ?? ??? ?? ?? ???????? ???????? ?? ??????? ????? ?? ???? ?? ??? ??????? ????? ?? ??? ????? ??? ??, Microsoft ??????? ???? ?? ???? ?? ????? ??????? ????????? ???? ??? ???? ?? ????, ??????? ?? ???????? ?? ??? ??? ?? ???????? ?? ????? ?? ??? ??? ????? ??? ?? ??????? ???? ?????? ?? ??????? ?????

????? ??????? ?????????? ?? ????????? ???? ?? ??? ??? ?????? ???????? ?? ???????? ??? ?? ???? ??????? ???? ????? ?? ??? ?? ???????? ?? ??? ???????? ???????? ?? ????????? ???? ?? ??? ???? ????????? ?????????? ?? ??????? ???? ?? ??? ?? SQL ????? ?? ??? ???

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

  • ???? ??????? ?? ??????? ?? ?? ???? ???????? ?? ???????? ???? ?? ??? ????
  • ?? ??????? ?? ??? ?????? ??????? ?????
  • ?? ??????? ?? ??? ????? ??? ?? ???? ???
  • ????? ?? ??? ????? ?? ?? ???????? ???????????? ?? ???? ???

HIGH-risk ?????

????? ?? ??? ??????? ??? ????? ??? ???? ????? ????? ????????? ???? ?? ?? ???? ????? ??????:
  • ????? ????????? ??????? ?? ????
  • ????? ?? ??? ??? ???????? ?? ???? ???? ??? ?? ????? ?? ??? ???? ????? ???
  • ????? ?? ????? ?? ??????? ?? ???? ????? ?? ????????? ?????
  • ????? ?? HTTP ?????, ???? Microsoft ??????? ?????????? ???????? (IIS) ?? Apache ?????? (?????? ?? ???: SQL Server 2000 ?? ??? SQL XML.)
  • ????? ?? ???? ???? ????? ???? ???? ????
  • ????? ?? ???????? ??? ?-??? ??????? ?? ????? ???? ?? ??? SQL ??? ?? ????? ?????
????? ?? ??? high-risk ????? ?? ??? ?????? ?? ???? ????? ??? ????????: ???? ?? ????? ?? ?????? ????? ?????

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

  • ?????? ????? ????? ?? ??? ??: ????? ?? ?? ?????? ????? ?? ??? ??? ?? ???? ?????? ?????? ???
  • ????? sweep ??????????: ????? sweep ?????????? ?? ????? ??????? ?? ??? ?????? ??????? ????? ???? ??? ??? ???? ??????? ???? ?? ??? ?? ???? ????? ?? ???????? ???? ???? ???????? ?? ?? ?????? ?? ?????????? SQL Server ??????? ????????????? ?? SQL ????? ?????? ?? ?????-??? ????? ???????? ?? ???? ?? ???? ??:
    • ??? ????? sweep ???? ??????? ????? ???? ??, ?? ??? ?? ?? SQL ????? (???? ?? SQL Server ??????? ???? ??, ?? ????? ?? SQL ????? ?? ?? AutoClose ??? ???????) ??????? ?? ????? ?? ?????? ???? ??? ????? ??, ?? ????? ????? ???? ??????? suspect ??????? ?? ???? ??? SQL Server ??????? ?????? ?????????? ??? .mdf, .ldf ?? .ndf ????? ????????
    • ??? ????? sweep ?????????? ??? Microsoft ??? ???? (MSSearch) ????? ??? ?????? ???? ?? ?????? ???? ??? ????? SQL ????? ?????? ?? ?????-??? ????? ??, ?? ?? ????? ??? ?????? ?? ??? ?????? ????? ?? ?????
  • ???????? ????????? ????????????: Microsoft ??????? ????? ??? CD ??????? ?????? ?????????????, ???? ?????? ???, ?? ?????? ????? ?? ?? ??????? ?? ????? ?? ????? ?? ??????? ???? ?????? ?? ??????? ?? ???? ??? ?? securing ?? ???? ??? ??????? ????? ??? ?? ?? ?????? ????? ?? ???? ???? ?????? ?? ???????? ?? ???? ???????? ???? ??? ??? ???? ?? ??? Microsoft ?????? ??? ??????? ???? ?? ??? ????? Microsoft ??? ???? ?? ????:
    HTTP://www.Microsoft.com/Security/
  • ????????????? ??????????: ????????? ?? ??????? ?????????? ?????????? ???? ????? ?? ????, ???? ???????? ?? ??? ??????? ????? ???? ?? ?? ?????????? ?? ??????? ??? ???????? ?? ????????? ?? ??????? ?????????? ?? ????? ??? ??? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? ????? Microsoft ??? ???? ?? ????:
    HTTP://www.Microsoft.com/protect/computer/spyware/default.mspx
    ??? ??, Microsoft Microsoft Windows ?????????????? ?????????? ??????? ????? ???????, prevalent ?????????????? ?????????? ?? ??????? ?? Microsoft Windows Server 2003, Microsoft Windows XP, ?? Microsoft Windows 2000 ??? ??? ???????? ?? ??? ?? ??? ???? ???Microsoft Windows ?????????????? ?????????? ??????? ????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
    890830Microsoft Windows ?????????????? ?????????? ??????? ????? ??? ??? ???? ???????, prevalent ?????????????? ?????????? ?? Windows Vista, Windows Server 2003, Windows XP ?? Windows 2000 ??? ??? ???????? ?? ???????

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

?? ?? ???? ????????? ?????????? ???????? ???????? ????, ????????? ???? ?? ?? ????? ????? ??????? ?? ?????????? ????? ???????? ??? ??? ??????? ?? ??????????? ?? ??????? ?? ?? ???? ??? ??? ???? ????????? ???? ?? ?? ??????? ??? ???? ??????? ?? SQL ????? ???? ?? ???? ????? ???? ?????? ??? ???????, ?? ??????? ????? ??, ??? ???? ????????? ?????????? ???? ?????? ??????? ?? ??? ????? ?? ????
  • SQL ????? ???? ???????

    ?? ??????? ????? ?? ?? ??? ?? ????? ???? ??? ????????? ?? ??:
    • .mdf
    • .ldf
    • .ndf
  • SQL ????? ????? ???????

    ?? ??????? ??????? ?? ?? ????? ????? ??? ?????????:
    • .bak
    • .trn
  • ?????-??? ?????? ??????
  • ??????????? ??????? onwards OLEDB SQL 2008 ??? ?????????? ?? ??? ????? ???? ???
  • ?????????? ???? ?? ???????? ???? ???? ??

    ???:??? ???????? ?????? 2005 ???? ?? ???????? ?????? 2008 ???? ???? ?????????? ?????? ????????? ??DataDir???????? ?????? ?? ?????? ?? ???? ???????? ??? ??, ?? ?? ?????????? ?? ?? C:\Program Files\Microsoft SQL Server\MSSQL.X\OLAP\Data. ??? ?? ???????? ?????? 2000 ?? ????? ????, ???????? ??????? ?? ????? ?? ???? ?????????? ?? ????????? ???? ?? ????? ?? ???? ???? ??? ???? ?? ???, ????? ????? ?? ???? ????::
    1. ???????? ?????? ???, ????? ?? ????-????? ????, ?? ???? ??? ????? ???????.
    2. ????????????? ????? ???, ????? ?????????????? ?? ????? ????..
    ?????????? ?? ??????? ????? ???? ?????? ???????.
  • ?????????? ?????? ???? ???????? ?? ????? ????? ??? ???? ??? ?? ???????? ???? ??????? ??????? ???? ??

    ???:????????? ?????? ?????????? ????????? ?? ????? ??? ???????? ?????? 2005 ?? ???????? ?????? 2008 ??????? ??????? ?? ???? ??TempDir???????? ?????? ?? ?????? ?? ???? ???????? ??? ??, ?? ??? ???? ??? ?? ?? ??? ????? ??, ?? ??????? ?????????? ?? ????? ???? ???? ??? ?? ?????????? ??? C:\Program Files\Microsoft SQL Server\MSSQL.X\OLAP\Data ??? ??? ?? ???????? ?????? 2000 ?? ????? ????, ?????????? ??????? ??????? ???????? ??????? ??? ???? ?? ????????? ???? ?? ????? ?? ???? ???? ??? ???? ?? ???, ????? ????? ?? ???? ????::
    1. ???????? ?????? ???, ????? ?? ????-????? ????, ?? ???? ??? ????? ???????.
    2. ????????????? ????? ???, ????? ?????????????? ?? ????? ????..
    3. ????? ??????????????, ?????
    Note the directory underTemporary file folder.

    Optionally, you can add a second temporary directory for Analysis Services 2000 by using the TempDirectory2 registry entry. If you use this registry entry, consider excluding from virus scanning the directory to which this registry entry points. For more information about the TempDirecotry2 registry entry, see the "TempDirectory2" section of the following Microsoft Developer Network (MSDN) Web site:
    http://msdn.microsoft.com/en-us/library/aa902654(SQL.80).aspx#sql2k_anservregsettings_topic52
  • Analysis Services backup files

    ???:By default, in Analysis Services 2005 and in Analysis Services 2008, the backup file location is the location that is specified by theBackupDir???? By default, this directory is C:\Program Files\Microsoft SQL Server\MSSQL.X\OLAP\Backup. You can change this directory in the Analysis Services instance properties. Any backup command can point to a different location. Or, the backup files may be copied elsewhere.
  • The directory that holds Analysis Services log files

    ???:By default, in Analysis Services 2005 and in Analysis Services 2008, the backup file location is the location that is specified by theLogDir???? By default, this directory is C:\Program Files\Microsoft SQL Server\MSSQL.X\OLAP\Log.
  • Directories for any Analysis Services 2005 or Analysis Services 2008 partitions that are not stored in the default data directory

    When you create the partitions, these locations are defined in the?????? ????????Processing and Storage Locationspage of the Partition Wizard.

Considerations for clustering

?? ???? SQL Server ??????? ?? ????????? ?????????? ??? ???? ???, ????? ???? ?????? ????????? ???? ?? ????????? ?????????? ?? ??????? ??????? ????? ????? ??????? ????? ???? ????????? ?? ?????????????? ?? ???? ??? ???? ????????? ???????? ?? ?????? ?????

??? ?? ???? ??????? ?? ????????? ?????????? ??? ??? ???, ?? ????????? ???? ?? ?? ?? ????? ?? ??????? ????? ???????? ??:
  • Q:\ (???? ??????)
  • c:\Windows\Cluster
??? ?? ????? ??????? ?? ???? ????? ?? ??? ?? ????? ????????? ??? ????? ?? ???, ???? ????? ??????? ?? ????? ???????? ????? ?? ???? ????

??????

?????? ??????? ?? ??? ??????? ???????, Microsoft recommends ??????? ??????? ????? ???? ?? ??? ??????? ???? ??????? ???, Microsoft ?? ????? ??? ???? ?? ????, ?? ?? ????? ?? ?????????? Bulletins??????:
HTTP://www.Microsoft.com/Security/
????????? ???????, ??????? ?? ??????? ???? ?? ??????? bulletins, ????, SQL Server ??????? ?? ???? ??? ??????? ??????? ?????? ?? ??? ????? Microsoft ??? ???? ?? ????:
HTTP://www.Microsoft.com/SQL/technologies/Security/default.mspx
???? ??????? ?? ??? ???????? ????????? ????? ?? ???? ??? ??? ??????? ??, Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
250355????????? ?????????? ??????? ?????? ?? ??? ?????? ?? ???? ?? ???? ??

???

???? ID: 309422 - ????? ???????: 17 ??????? 2011 - ??????: 3.0
???? ???? ???? ??:
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
??????: 
kbsql2005cluster kbinfo kbmt KB309422 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:309422

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

 

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