PRB: ???? 'Temp_db' ????? ?????? ??? ????? ???? SQL

?????? ????????? ?????? ?????????
???? ???????: 158586 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

???????

??? ????? SQL Server ???? ??? ??? tempdb ?? RAM (??? ?????? ?????? 'tempdb ?? RAM' ???? ???? ?? ?? ???? ??? ????? ?? ??? ????? ???? ???? ???????? ??????? & -f & ?? ??? ???????) ? ???? SQL Server ???? ??????? ???? ???? ??? ??? ???? ?? ??? ???? 'temp_db' ????? ??????.

?????

??? ??? tempdb ?? RAM SQL Server ????? ????? ????? ???? RAM ??? ????? ?? 'temp_db' ? ?? ????? ????? ?????? tempdp ??? ??? ??????. ??? ??? ???? ????? ?????? ?? ??? 'temp_db' ? ????? ?????? ????? ????? ?? ???? sysdevices; ???????? ?? ???? ????? tempdb.

?????? errorlog SQL Server ??????? ?????? ?? ????? ?????:
??? ?????? ????? ?? ???????? ??????? ?? ?????? 'sysdevices' ?? ???? ???? 'sysdevices' (????? 2601)

crdb_tempdb: ?? ???? ??? tempdb ??? RAM; ?????? RAM ??? ????? ?? ?? ???? ????? ?? ?? ???? ???? ????? ????? tempdb.

????? ?????? ?????? ???? ????? ??? ??????? ??? ?? ????? ??????? ????? ??? ???? ?????.



??? ????? ??????? tempdb ????? ??? ??????? (??? ???? ??????? ?? ????? ??? ????? ???? ?? ???????) ?? ??? ??????? ????? ????? ??????? ?? ???? ??? ????? ??????:
msg 906: ?? ?? ?????? ???? ???? ?? sysobjects ?????? ??? ?????? ?????? 'sysobjects' ?? ????? ???????? 'tempdb'....

msg 615: ???? ?????? ??? ???? ???? ????? ???????? = 2? ????? = 'tempdb'....

??? ????? ?????? ??? "tempdb" ??? ??? ????? ?????? ??? ??? ????? ????? ????? ???? ??? ???? ??????.

???? ??????

???? ?????? ????? ??? ???? ??????? ?? ????? ??? ?????? BINN ??? ?? ????? SQL Server (??? ???? ??????? SQL60\BINN ?? SQL Server 6 ?? MSSQL\BINN ?? SQL Server 6.5). ?? ?????? ??? ??????? ?????? ???? ????? ????? ??????, ???? ????? SQL Server:
sqlservr - c -m - T3609 - T4022



?????? ?????? ?? ????????? -m ???? SQL Server ?? ??? ???????? ??????. ??? ?????? ??????? ????? ??? ??? ????? ??????? ????? "??? ????? ??????" ??? ??? ????? ??? ??????. ???? ?? ????? ??? ?????? ??????? ?? ???? ?????? ????? ?????? ??? SQL Server (??? ???? ??????? SQL Executive, ?????? ??????, ???.).

????? ????? ???? SQL ??????? & "ISQL/w &" ??????? ?? SQL Server. ???? ?? ??? ???? ?????? ??? ??????? ????? ??????? SQL ???? ??? ???? ?????? ?? ??? ???????? ??? ??????? (???? ?????? tempdb). ????? ???????? ?????? ????? ?????? ?????? ?????? ??????? ???? 'temp_db' ???? ???? ????? SQL Server ??? ??? ?????? ??? ??? ???????.
sp_dropdevice 'temp_db'

??? ??? ?? ?? ????? ?? ????? ?????? ???? ??? ???? tempdb ??? ?????? ? ???? ??????? ????? ????? ????? ???????? ???. ????? ???????? ??? ??? ?? ???? ????? ???????? ????? DROP ????? ?????? ???? ???? ??? ?????? temp_db.



??? ????? ??? SQL Server ???? ????? ??? ????? ??????? ????? ?? ??? ??? tempdb ???? ???? ?? RAM ?????? ????? ?????? ??????? ???? tempdb ??? ???? ??? ?????.
sp_configure 'tempdb ?? RAM' 0
????? ????? ?? ?????

??? ?? ??? ??? tempdb ??? ???? ??? ?????? ????????? ?? ??? ????? ???????? ????????? (???? 2 ???? ???? ??? ????????). ????? ?????? ????? SQL Server. ?? ??? ???????? ?????? ??? ????? ?????? ?? temp_db ??? ????? ???? ???? ????? ?? ?? ?????? tempdb ??? ??? ?????? ??????.

???????

???? ???????: 158586 - ????? ??? ??????: 03/???? ??????/1435 - ??????: 3.0
????? ???
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt KB158586 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????158586

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

 

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