??? ?? ????? ?????? ????? ???????? ?? SQL Server 7.0 ? SQL Server 2000 ?? Microsoft SQL Server 2005? ????? ????? ????? ????? ????????? ????????.
????? ????? ??? ??? ??? ????????? ????? ???? ?? ?????? ???? ?????? ???? ????????? ???? ???? ?? ???? ??? truncations ??? ????????? ???? ??? ??????? ?????? ???? ?????? ?? ????? ?????????? ??? ?????????.
??? ???? ?? ??? ??????? ?? ??? ????????? ???? ????? ???? ?????? ???? ????? ?? ???? ?????. ???? ???? ????? ????? ????? ??????? ??? ??? ??? ??????? ?????? ????? ????? ???????? ??? ???? ????? ???? ?? ???:
???: 9002
???? ???????: ???? 17,: 2
??? ????? ?? ??? ????? ???????? '%. * ls' ?????.
??? ??? ?????? SQL Server 2005? ????? ????? ??? ?????? ??? ???:
???: 9002? ???????: 17,
??????: 2
??? ????????? ?????? ???????? '%. * ls' ?????. ?????? ?????
?? ???? ?? ???? ????? ?? ????? ????? ?????????? ???? ?????? log_reuse_wait_desc ??
sys.databases
???????? ??? ????? ????? ???? SQL Server ?? ????? ????? ???????? ?????? ?? ???? ??? ????? ?????? ??? ????????. ?????? ??? ???? ?? ????????? ??? ????? ??????? ?? ??? ??????? ???? ??????? "????? ????? ??? ?????" ?? "??? SQL Server".
???????? ??? ???? ?? ???? ?? ????? ??? ???????? ?? ??????? ???????:
- ??? ??? ??????? ???? ????.
- ?? ???? ????????? ??? ???? ?? ???????.
- ????????? ?? ?????? ????? ?????? ???????.
- ?? ???? ?????? ?? ??????.
- ?? ???? ???.
??????? ????
?? ???? ????? ??? ???????? ???? ??????? ??????? ?? ????? ?????????.
?????? ?? SQL Server 2005? ????? ??????
log_reuse_wait ?
log_reuse_wait_desc??????? ?? ????? ????? sys.databases ?????? ??????? ?????? ????? ?? ??? ????????? ????? ????? ???????? ????? ?? ??? ???????? ?? ??? ?????????.
????????? ??? ????? ???
???? ????????? ????? ??? ????? ??? ??? ?? ???? ??? COMMIT ?? ?????? ??? ?????? ??????? ?????. ???? ??? ?????? ????? ????? ???? ??? ??????? "????? ?????" ?? ??? SQL "?????" ??? ??? ????? ???????. ???? ????? ????????? ???? ??? ?? ???????. ????? ?? ???? SQL Server ??????? ?? ?????? ???? ??? ??? ???? ???????? ??? ???????? ?? ???? ???????. ????? ??????? ???? SQL ???????? OPENTRAN DBCC ?????? ?? ???? ?????? ???? ?? ????? ?????? ?? ??? ????.????? ?? ?????????
??? ??? ????????? ??????? ???? ??? ????? ???????? ??????? ???? ???????? ?? Microsoft Knowledge Base:
295108
(http://support.microsoft.com/kb/295108/
)
??????? ??? ????? ?? ????? ??? ???? ?? ?????? ??????? ???? ??????
171224
(http://support.microsoft.com/kb/171224/
)
??? ??? ???? ????? "?????" SQL ????????
???????? ??? ???? ???? ??????? "DBCC OPENTRAN" ?? SQL
Server ??? ??? ????????.
????? ????????? ???? ?? ???? ?? ????????? ??? ????? ???:
- ????? ??????? ???? ????? ?? ????? ????? ????
???????? ???????.
- ????? ????? ?? ????? ????? ???? SQL Server ????? ????? ??? ???? ????????? ??????? ?? ??????? ????? ????????? ???????. ??? ??? ????? ??????? ?????? ?????? ????????? ????? ????? ????? ???????:
????: Msg 6401? ????? 16? ???? 1? ????? 13 ?? ???? ??????? ?????????. ??
?? ?????? ??? ???????? ?? ???? ??? ??? ?????.
???? ??? ??? ????? ???? ?????? ??????? ????? ??: - ???? ???? ????? ??? ????? (?? ???? ???????? ???????? ?? ????? ???? ?? ????? ??).
- ???? @ @ TRANCOUNT ??? ????? ?????? ???
?????? ??? ?????? ??????? ?? ????? ?? ??? ????? ?? ?????.
- ????? ????????? ???????? ????????? ?? ???
@ @ TRANCOUNT ?? "?????" ??? ???? ??????? @ @ TRANCOUNT ?????
????? ??? ??????? ??? ???? ???.
- ?????? ???? ??? ???? ????? ??? ?????? ?????????.
(??? ??? ????? ?????????!)
- ????? ???????? ??????.
- ????? ???? ???????? ??????? ???? ?????????. ???? ??? ???? ??????? ???? ???? ????????? ???? ??????? ??? ?????????? ????? ????? ???? ?? ??? ???????? ?????? ???????? ???????? ????? ??? ??????? ??? ????? ??? ?????? ????????.
- ??? ??????? ???? ?? ????? @ @ TRANCOUNT ??????
?? ???? ???? ??????? ??????.
- ???? ??????? ?? ????? ???? ????? ??????? ??????
??????? ? SQL Server ??? ????? ???.
- ???? ?????????. ???? ??? ?? ??? ????? ?????? ????? ????????? SQL Server ??????? ??? ??? ??? ?? ???? ?????. ????? ?????? ???? ????? ?????? ???? ??????? ??? ?????? ?? ??????? ????????? ?????? ??? ?? ???? ??????? ??? ???? ???????? ?????? ??????? ?? ???? ??? ??????. ??? ????? ???? ??????? ???? ??? ?????? ?? ?????? ??????? ????? ?????? ????????? ???? ?? ??????? ?? ?????. ????? ????? ????? ????? ???????. ????? ?? ????????? ??? ?????
?????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
164221
(http://support.microsoft.com/kb/164221/
)
????? ????? ???? ????????? ?? ??? ??????? ODBC
????????? ???? ????
??? ?????? ????? ??????? ?? ????? ????? ????????? ??? ???? ???????? ?? ????????. ??? ??? ?????? ????????? ????? ?????? ?? ???????? ???? ????? ???? ??? ?? ??? ????? ?? ??? ????????? ?? ?? ??? ?????. ???? ?? ???? ????? ????? ???????. ??? ???? ?????? ????? ????? ?????? ?? ?????? ????? ????? ???????? ??? ????? ????? ????? "??? ???????? ???????" ?? ????? ??????? ?????? ??? ??? 9002. ????? ?? ????????? ??? ?? ??? ???? ??? ???? ??? ????? ?? ????? ??????? ??????? ???? ??? "???? ?? ?????????" ?? ??? ???????. ???????? ??? ???? ???? ???? ???? ?? ????? ?????? ????? SQL Server ??????? ????????? ????.
????????: DBCC DBREINDEX ?????? ????
???? ????????? ?? ???? ????????? ?? SQL Server 2000
??? ??????? ??? ????????? ?????? ?????? ????? DBREINDEX DBCC? ????????
????? ??? ??? ????? ???? ?????? ????? ??????? SQL Server 7.0 ??
??? ????????? ??????? ???????? SELECT INTO ?? "??? ????" ???
"Trunc. ????? ?????? chkpt. "????? ?????.
??? ????? ?? ?? ????? ??? ????????
??? ?? ???? ????? DBREINDEX ?????? ????? ??? ??????? ???? ????
???? ??????? ?????.
??? ??????? ?? ????? ?????????? ??? ????????
???? ????? ??? ?? ??????? Microsoft Knowledge Base
??????:
232196
(http://support.microsoft.com/kb/232196/
)
???? ??? ??????? ????????? ????? ??? ??????? ?? ?????? ??????????
??? ??? ?????? SQL Server 2000 ???????? ??? ????? ????? ????? ?????? ???? ??? ???? ?? SELECT INTO? ??? ??? ????? ?? ??? ???? ??? ????? ????? ????????? ??? ????? ????? ????????? ??? ?????????. ??? ????? ?? ?? ??? ???? ?? ????? ????? ????? ???????? ???????? ?? ??? ??? ??? ????? ???????? ???????? ??? ???? ??? ??? ????? ????????. ?? ????? SQL Server 7.0 ??? ??????. ????? SQL Server 7.0 ??? ???????? ???? ?? ???????? ???? ?? ???? ?????? ??????. ????? ?????? ??????? ????? ???? ????? ?? SQL Server 2000 ??? ???? ?? SQL Server 7.0 ?? ??? ??? ???????? ???? ??? ??? ????? ???? ???? ?? ????? ??????.
??????? ?????? ??? ?????? ???? ???????
??? ????? ??????? ??? ???? SQL ??? ????? ??????? ??????? ?? ???? ??? ??????? ?????? ??????? ??? ??????.
??? ???? ??????? ????? ?? ????? ??????? ???? ????? ?????? ?? ?????? ???? ?????? ???????. ???? SQL Server? ??????? ????? ?????? ?????????. ???? ???? ?? ??? ????? ??????? ??????? ??? ?????? ???? ????? ??? ?????? ???? ??? ?? ???? ???? ?????? ????????? ????? ??. ???????? ??? ???? ????? ?? ?????? ?? ???? ?????? ??? ?????? SQL Server TDS ???? (????? ???? ???? ?????? ?? ??????). ??? TDS ??????? ???????? ??? ??????. ?? ???? ?????? ???? ?????? ?? ?????? ?????? ??? ???? TDS? SQL Server ?????? ??????? ??????? ??? ??? ?????? ???? ???? ????? ?????? ?? ?????? ???????. ?? ????? SQL Server ?????? ???? ?????? ?? ???????? (????? ?????? ???? ???????? DBNEXTROW/????????? ?? ???????????/?????????? ?? ????????/????????? ??? ???? ??????).
???? ???? ?? ????? ??????
???????? ??? ???? ?????? ???? ????????. ?????? ????
?? ??? ??? ??? ???????? ?? ?????? ???????.
?????? ?????? ??? ?????? ??? ??????? ?????? ????? ????? ??? '??? ????' false
?? ??? ??????? ??? ????? ?? ???? ????? ????? ??? ?????? ?? ???? ????? ????? ??? "???? ?????".
?????? ??? ?????? SQL Server 7.0 ? SQL Server 2000.
???? ?? ???? ??????? ??? ????????? ?????? ???????? ??? ??? ??? ????????? ?????? ??????. ?? ?????? ??? ????? ??????? ??? ????? ??????? ?? ?? ?????? ???? ?????? ???? ???. ????? SQL Server 7.0 ????? 9002 ?? ??? ??????. ?? ????? ??? ??????? ??? SQL Server 2000.
?? SQL Server 2000? ??? ??? ???? ??????
????? ???????? ??? ??????? ?????? ??????? ???? ??? ???? ???? ????? ?????? ??? ??????? ?????? ????????. ??? ???? ?? ???? ????? ??? ??? ??????
??????? ???????? ??? ??????? ?? ??? ?????. ?? ???? ??? ???? ?????? ??? 9002 ?????.
??????? ???????? ???? ???? ????? ????? ?????????
???? ?????. ??? ???? ?? ??????? ???????? ?? ?????? ???? ??
????????:
- ??? ????? ??? ???? ????.
- ?????? ????? ?????? ??????.
- ?????? ??????? ??? ?????.
??????? unreplicated
????? ????? ??? ??? ???????? ?? ????? ??????
???? ??? ??? ?????? ????? ????????. ?????????
???? ???? ??? ???????? ???? ??? ????? ????? ???????? ???? ????? "????? ????????."
?? ??? ??? ??? ?????????? ??? ????????? ??? ????? ???? ???
???? ?? ??? ????? ????????? ??? ??????? ??? ?????? ???? ???
??? ????????? ?????? ???????? ??????? ?????? ??? ????? ?????. ??? ???
????? ?? ?????? ???? ??? ????? ?? ????? ??? ????????? ??
????? ??????
???? ? ?? ????? ??? ??? ???????? ??????
??? ????????? ??? ????? ??????. ????? ??????? DBCC
???? Transact-SQL OPENTRAN ?????? ???? ??? ?????
????????.
????? ?? ????????? ??? ????? ??????? ????? ????????? unreplicated? ???? ???????? "sp_replcounters" ? "sp_repldone" ?? "??? SQL Server".
????? ?? ?????????? ???? ??? ????? ???????? ??????? ???? ???????? ?? Microsoft Knowledge Base:
306769
(http://support.microsoft.com/kb/306769/
)
?????: ??? ????????? ?????? ???????? ???????? ???? ?? ??? ????????
240039
(http://support.microsoft.com/kb/240039/
)
?????: DBCC OPENTRAN ?? ??????? ??????? ????? ????????
198514
(http://support.microsoft.com/kb/198514/
)
?????: ??????? ??? ???? ???? ???? ??????? ?? ??? ?????????
??? ????? ??? ????????? ??? ????? ???????? ??????? ?? ????? ????? ??????? (????). ???? SQL Server ?????? ???????? ??? ????? ???????? ???? ????? ?????? ????? ???? ??? ???????? ??? ????? ????? ????? ????? ???????? ???????? ????. ????? ??? ????? ?? ????? ???? ?????? ?????? ??? ??? ????? ???????? ???????? ????. ???? ?? ???? ???????? ?? ????? ?? ???? ?????: ???? ????? ????????? ?????? ?????????.
- ??????: ???? ????? ????? ?? ????? ?? ??? ????? ??? ???? ?????? (LSN) ???? ???? ???? ??????? ???? (??? ????? ???). ?????? ????? ????? ?? ????? ?? ?????? ????? ???. ?? ???? ???? ????? ??? ?? ??? ?? ????? ????? ????? ?????? ????. (??????? ??? ????????? ?? ????? ?????? ??? ??? ?? ?? ????????.)
- ???? ?????????: ????? ?? ????? ???? ???? ??? ????????? ?????? ?????? ????? ??? ?????? ??? ????? ?? ??? ???????? ?? ????? ?????????.
- ?????? ?????? ?????????: ??? ??? ??? ???????? ??? ????? ?????????? ??? ????????? ?? ??? ???
???? ????? ????????? ?? ?????? SQL Server ??????? ???? ??? ????? ????
????????.
????? ??? ???? SQL ??? ????? ??? ????? ???????? ???? ????? ??????? ??? ??????? ?? ????? ?????? ?????? ????? "??? ????? ????? ??? ????" ??? ????? ???????. ?? ??????? SQL Server ?????? ????? ?? ??? ????? ???? ??? ?????? ?????? ????????? ?? ????? ?????????. ???? ????? ????? ????? ??????? ???? ????? ?? ????? ??? ???? ?????? LSN ?? ???? ??????? ???? ??? ???? ?????? ????????? ?? ?????? ??? ??????? ???. ??? ????? ????? ????????? ???? ????? ??? ????? SQL Server ??? ???? ??? ????? ?????. ??? ????? SQL Server ??? ???? ??? ????? ?? ??????? ?? ????? ??????? ????? ?? ??? ???? ???? ????? ?????? ?????? ????????? ?? ????? ?? ??? ????? ??? ???????? ?????? ????? ?? ?????.
????? ?? ?????????? ???? ??????? "????? ??? ?????? ??? ????????" ?? "??? SQL Server". ???????? ??? ???? ????? ?????? ????? ???????? ??????? ??? ?? ?????? 190 ?? "???? SQL Server 7.0" (Soukup? ???. ???? Microsoft SQL Server 7.0 ?? Microsoft Press? 1999)? ????? ??? ????? 182 186 ? "???? SQL Server 2000" (??????? ?????. ???? Microsoft SQL Server 2000? Microsoft Press? 2000).????? ?????? SQL Server 2000 ? SQL Server 7.0 ???? ?????? ????? ???????? ??????????. ????? ??????? ??? ???????? ???????? ?? ??? ?? ????? ??? ????????? ????? ??.
????? ?? ????????? ??? ????? ???
?????? ???? ?? ???? ??? ??????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
315512
(http://support.microsoft.com/kb/315512/
)
?????????? ?????? ?????? ????? ???????? ?????????? ?? SQL Server
?????? ??? ??? ???????? ????? ??? ??? ??? ????????. ??? SQL Server ??????? ??? ??? ??????? ???? ???? ?? ??? ??? ??????? ??? ????? (??? ???? ??????? ????????? ??????? ???). ??? ???? ????? ???? ???? ??? ????? ?? ????? ????? ??? (??? ???? ??????? ?? ?????? Windows ?? ???????? ?????
dir )? ???? ??? ????? ?????. ??? ???? ???? ????????? ?? ??????? ???????? ???? ???.ldf ???? ??? ??????? ?????. ??? ??? SQL Server ????? ??? ??? ??? ???????? ?? ???? ??? ????? ?? ????? ?????? ???? ?????.
????? ?? ????????? ??? ????? ?????
????? ????????? ???? ??? ????? ???????? ??????? ???? ???????? ?? Microsoft Knowledge Base:
256650
(http://support.microsoft.com/kb/256650/
)
????? ????? ??? ????????? SQL Server 7.0
272318
(http://support.microsoft.com/kb/272318/
)
????? ??? ????????? ?? SQL Server 2000 ?? DBCC SHRINKFILE
????? ?? ????????? ??? ??? ????????? SQL Server 6.5
?????????? ???? ??? ??? ??????? ?????? ???? ??????? ?? ????? ????? Microsoft:
110139
(http://support.microsoft.com/kb/110139/
)
????? ??? ??? ????????? SQL
????? ????? ???? ??????????? ???? ?????? ???? ????? ?? ????? ????? ?? SQL Server 2005
?? SQL Server 2005? ????? ??????? ????? ??? ????? ???? sys.dm_tran_database_transactions (DMV) ?????? ???? ??????????? ???? ?????? ????? ????? ?? ????? ?????. ??????? ??????? ?? sys.dm_tran_database_transactions DMV ???? ?? ???? ?????:
- database_transaction_log_bytes_used
- database_transaction_log_bytes_used_system
- database_transaction_log_bytes_reserved
- database_transaction_log_bytes_reserved_system
- database_transaction_log_record_count
????? ????????? ???? sql_handle sys.dm_exec_requests DMV ?????? ??? ?? ??????? ??????? ???? ?????? ????? ????? ?? ????? ?????. ????? ?????? ???? ?? ???? ???????? ??? sys.dm_tran_database_transactions DMV ? sys.dm_tran_session_transactions DMV ??? ???? transaction_id? ?? ????? ??? ?????? ?? sys.dm_exec_requests ??? ???? session_id.
????? ?? ????????? ??? sys.dm_tran_database_transactions DMV? ????? ???
sys.dm_tran_database_transactions (TRANSACT-SQL)
(http://msdn2.microsoft.com/en-us/library/ms186957.aspx)
???? ???? ????? Microsoft (MSDN).
????? ?? ????????? ??? sys.dm_tran_session_transactions DMV? ????? ???
sys.dm_tran_session_transactions (TRANSACT-SQL)
(http://msdn2.microsoft.com/en-us/library/ms188739.aspx)
???? MSDN ??? ???.
????? ?? ????????? ??? sys.dm_exec_requests DMV? ????? ???
sys.dm_exec_requests (TRANSACT-SQL)
(http://msdn2.microsoft.com/en-us/library/ms177648.aspx)
???? MSDN ??? ???.
???? ???????: 317375 - ????? ??? ??????: 04/?????/1433 - ??????: 1.0
????? ???
- 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 2000 Standard Edition
- Microsoft SQL Server 7.0 Standard Edition
| kbsqlsetup kbinfo kbmt KB317375 KbMtar |
????? ???????: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????
317375
(http://support.microsoft.com/kb/317375/en-us/
)
???? ??? ??????
