BUG: sp_change_secondary_role ??? ?? 3101 ??? ??? ??? ???? ????? ?????????? ??? ????????? ???????

?????? ????????? ?????? ?????????
???? ???????: 294397 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 352508 (SHILOH)
????? ???? | ?? ????

?? ??? ??????

???????

????? sp_change_secondary_role ??????? ?????? ??? ?????? ????????? ??? ????? ??? ??? ?????? ??? 3101 ??? ????? ???????? ?????????:

  • ??? ????? ???? 1 ??????? @ ?????. ???? ?? ??? ?? ????? ???? ???????? ???? ???????.
  • ???? ??? ????????? ??????? ???? ??? ????? ???? ??????? ??? ???? ??? ?????????.
??? ??? ?????? ???? RESTORE ??? ??? ?????? ????????? ???????? xp_sqlmaint ????? ??????? ??? ??? ?????? ???????:
???? ????? ???????? - ??????
????? ???????? ?????? - ??????
[Microsoft SQL-DMO (SQLState ODBC: 42000)]
??? 3101: [Microsoft] [ODBC SQL Server ?????] [SQL Server] ???? ??? ???? ?????? ??? ??? ????? ???????? ??? ?????????.
[Microsoft][?????? ????? ???? SQL ODBC][SQL Server]??? ???? ????? RESTORE ??? ???? ??? ?????.
????? ????? 0
???? ?????
???????? ?? ????? ????? SERVER1\INST1.test_logshipping

????: ????? 22029 ? ????? 16 ???? 1? ??? 0
??? sqlmaint.exe.

?????

??? ?? ????? ??? ????? ??? ?????? ????? ??? ????? ???? ????? ?? ????????? ?? ??? ?????? ????? ????? ??????? sp_change_secondary_role ??????? ??? ???? ????????? ?????? ???? ????? ?? ????????? ?? ??? ??????. ??? ????? ??????? sp_change_secondary_role ??????? ?? ???????? ?????????? ??????? ?????? ?????? ??? ??????:

  • ????? ????? ???????? ????????? ??? ???????? ??????.
  • ??? ??? ????? ?????? ?? ????? ??? ?????.
  • ????? ???? ???? ??? ???? ??? ?????????.
  • ??? ??????? ??? ????? ?????? ?????.
  • ????? ????? ???????? ??? ?????? ??? ???? ?????.
  • ???? ??? housekeeping ??? ??? ????? ??? ??????? ?? ????? ?????? msdb ??? ??? ????????? ???? ????? ??? ???????.
??? ??? ??????? sp_change_secondary_role ????? ??? ????? ???? @ ????? = 1 (???? ?? ????? ???? ??????? ????????? ?? ??? ??????? @ ?????) ?????? 1 ?? ??????? ?????? ??????
ALTER DATABASE dbname SET SINGLE_USER
??????? ?????? ???? ????? ?????? ?? ?????? ?? ????? ?? ?????? ????? ?????? ????? ????? ?????????. ??? ????? ?? ???? ????? ????? ALTER ????? ?????? ??? ???? ????? ????? ?????? ?????? ??? ????? ??????? ??? ?? ???? ???????. ??? ????? ??????? 2 ?4 ???????? xp_sqlmaint ????? ??????? ??? ????? ????? ??? ?????? ??? ????? ????? ???? (spid) ????? ?? spid ??????? sp_change_secondary_role ?????? ?????? ??????? ???????. ????? ????? ????? ????? ?????? ?????? ??????? ?????? ????? spid ??????? ?????? ?????? RESTORE ??? ??? xp_sqlmaint ????? ?????. ??? ?? ???? ??????? sp_change_secondary_role ?????? ??? 3101.

???? ??????

????? ??? ?????? ?????? ??? ?????? ???????:
  • ???? ?? ???? ?? ????? ?????? ????? ??? ????? ??????? sp_change_secondary_role ?????. ?????? ?????? ???? ????????? ??? ???? ????? ??? ????? sp_change_secondary_role ???? ?? ???? ?? ????? ?????? ?????.

    - ?? -
  • ???? ????? ?????? ??? ??? @ ????? ??????? (@ ????? = 0) ????? ????? ??????? sp_change_secondary_role ?????. ??? ???? ??? ?? ???? ???????? ?? ???? ???????? ??????? ?????? ?????? ??? ????? ??????? ?????? ?????? ?? ?? ??? RESTORE ???? ?????.

?????

???? Microsoft ??? ???? ????? ?? SQL Server 2000.

??????? ????

?? sp_change_secondary_role ????? ???? ?????? ???? ???? ??? ?????? ????????? ????? ???? ??? ?????? ????????? ??? ??????.

?????

??? SQL Server ??? ??????; ???????: "????? ????? ?????? ??? ????? ????? ????? (Transact-SQL)"

???????

???? ???????: 294397 - ????? ??? ??????: 07/????? ??????/1425 - ??????: 3.3
????? ???
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Developer Edition
????? ??????: 
kbmt kbbug kbpending KB294397 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????294397

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

 

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