FIX: ??? ?? ???? ??????? ???? ???????? ?? ????? ???????? ??? ???? SQL Server ??? ??? ??? ?????? ??????? ?????? ???????? ??? ????? ?????? ?????????? ?? SQL Server 2008 ?? ?? R2 2008 ???? SQL

?????? ????????? ?????? ?????????
???? ???????: 2300689 - ??? ???????? ???? ????? ????? ??? ???????.
???? Microsoft Microsoft SQL Server 2008 ?????? Microsoft SQL Server 2008 R2 ???? ??????? ??????? ???????. ??? ???????? ?????????, ?? ????? ???? ????? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ?? R2 2008 ???? SQL ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

???? ??? ????????? ??????:
  • ?????? ??????? ?????? ???????? ?? ????? ?????? SQL Server 2008 ?? ?? Microsoft SQL Server 2008 R2.
  • ?? ????? ????? ????? ????????.
  • ????? ????? ????? ????????? ?????? ???????? ?????? ??? ????? ???????.
  • ?????? ??????? ????? ???????? ??? ???? SQL Server ??? ???????? ????? ?????????.
?? ??? ?????????? ???? ????? ?????????? ????? ????? ??? ?????? ??? ???:
????? System.Data.SqlClient.SqlError: "<database name="">_log" ??? ?? ??????? ???? ????. ?? ???? ????? ??????? ?????? ??? ???? ?? ????????. (Microsoft.SqlServer.Smo)</database>
??? ????? ?? ???? ????? ??? ????? ?? ??????.

??? ??? ?????? ????? ??????? ?????? ???????? ??? ????? ??? ??????? ?????? ????????? ????? ????? ????? ??????? ??? ?????? ??????? ????? ????????:
System.Data.SqlClient.SqlError: ?? ???? ?????? ??? ????? ?????? ?? ???? ????? '0xCB62FF76463A6BF86E8F769B541BA6483AFC2FF2'. (Microsoft.SqlServer.Smo)

????

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

SQL Server 2008 Service Pack 1

?? ????? ??????? ????? ???? ??????? ???? ??? ?? 10 ??????? ???????? ????? ?????? Service Pack 1 ?????? SQL Server 2008. ?????? ??? ???? ?? ????????? ??? ???? ??????? ???????? ???? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2279604???? ??????? ???????? 10 ? SQL Server 2008 Service Pack 1
????????? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? Microsoft ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
970365???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 Service Pack 1
Microsoft SQL Server 2008 ????????? ??????? ??? ????? ??? ????? SQL Server ?????. ??? ????? ????? ???? SQL Server 2008 Service Pack 1 ??? ????? SQL Server 2008 Service Pack 1. ???? ???????? ??? ????? ?? ????????? ???????? ?? ???? ???? SQL Server ?? ???? ???? ? SQL Server ???????.

SQL Server 2008 Service Pack 2

?? ????? ??????? ????? ???? ??????? ????? ?? ??????? ???????? 1 ????? ?????? Service Pack 2 ?????? SQL Server 2008. ?????? ??? ???? ?? ????????? ??? ???? ??????? ???????? ???? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2289254??????? ???????? 1 ????? ?????? Service Pack 2 ?????? SQL Server 2008
????????? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2402659???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 Service Pack 2

SQL Server 2008 R2

?? ????? ??????? ????? ???? ??????? ???? ??? ?? 4 ??????? ????????. ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? ???? ??????? ???????? ??? R2 2008 ???? SQL? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
2345451???? ??????? ???????? 4 ? R2 2008 ???? SQL
????????? ??????? ???????? ????? ?? ????? ????? ???? ??? ???? ????????? ??????? ?????? ???? ??????? ?????? ???? ?? ??????? ?? R2 2008 ???? SQL ??????? ???????. ???? ??????? ????? ????? ????? ?????? ???? ????? ??? ??? ??????? ??????. ?????? ??? ???? ?? ?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
981356???? R2 2008 ???? SQL ???? ?? ??????? ??? ????? R2 2008 ???? SQL

?????

???? Microsoft ?? ??? ??????? ???? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

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

  1. ?? ?????? ????? ???????. ??????? ?? ???? ?? ????? ???? ???? ?????? ????? ?????:
    use master
    Create Master Key encryption by password = 'Password01!';
    go
  2. ????? ?? ?????? ??? ????? ????? ?????? ??????? ???????. ??????? ?? ???? ?? ????? ???? ???? ?????? ????? ????? ?????? ????? ???????:
    create certificate cert_testDB_encryptDEK  authorization dbo
    with subject='Certificate to encrypt the DEK of testDB'
  3. ?? ?????? ????? ?????? ????? ????? ????? ????? ????? ?????? ??? ?????? ??????? ????????. ???? ??? ???? ?? ????? ???? ???? ?????? ????? ?????? ?????? ???? ?????? ????? ????? ????? ??????? ??? ???? ???? ??????? ???????? ??? ?????:
    create Database testDB
    use testDB
    Create database encryption key 
    with algorithm=AES_128
    encryption by server certificate cert_testDB_encryptDEK  
    
  4. ?? ?????? ????? ???????? ??????? ???????. ??????? ?? ???? ?? ????????? ???????? ???? ???? ?????? ????? ?????? ??????? ???????:
    Alter database testDB set encryption on 
    
  5. ?? ?????? ????? ????? ????????. ??????? ?? ???? ?? ????????? ???????? ???? ???? ?????? ????? ????? ??????:
    Alter database testDB set encryption off 
    
  6. ????? ??? ??????? ?????? ????????? ??? ?? ??????? ?????? ?????????? ??? ??? ????? ?? SQL Server.

?????

?????? ??? ???? ?? ????????? ??? ????? ???????? ???? (TDE)? ?? ?????? ???? ??????? ?????? Microsoft ??????? (MSDN) ???? ???:
??????? ???? ??? TDE
?????? ??? ???? ?? ????????? ??? "????? ????? ??????" ? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
935897????? ????? ?????? ????? ?? ?????? SQL Server ?????? ????????? ??????? ??????? ???? ?? ??????? ????
?????? ??? ???? ?? ????????? ??? ?????? ??????? ??????? SQL Server? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
822499???? ????? ????? ???? ??????? ????? Microsoft SQL Server
?????? ??? ???? ?? ????????? ??? ??????? ????? ???????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 2300689 - ????? ??? ??????: 09/?? ?????/1431 - ??????: 4.0
????? ???
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Workgroup
????? ??????: 
kbqfe kbfix kbsurveynew kbexpertiseadvanced kbmt KB2300689 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????2300689

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

 

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