INF: ????? ??? ??????? ??? Won't ??? ???? SQL

?????? ????????? ?????? ?????????
???? ???????: 173090 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

???? ??? ??????? ????? ????? ??? ??????? sp_configure ??? ??? ???? MSSQLServer ??? ??? ????? ????????? ??? ?????? sp_configure.

??????? ????

?? ???? ?????? ??? ????? ???? MSSQLServer ??? ???:
  • ?? Windows NT ????? ?????? ??????? ? ??? ????? ??????? ???????:
    ???? ??? ????? ???? MSSQLServer ??? \\servername 2140 ???: ??? ??? ????? Windows NT
    - ?? -

  • ?? SQL ????? ???? ? ????? ??? ???? ????? ?? ????? ??? ????. - ?? -

  • ?? ??? ??????? ???? net start mssqlserver ????? ??????? ???????:
    ??? ???? ??? ????? ???? MSSQLServer. ???? ??? ????? ???? MSSQLServer. ?? ???? ?????? ???. ????? ???? ?? ????????? ?? ???? ????? 3534 HELPMSG NET.
?? ??? ????? ??? ????? ?? ??? ????? SQL Server. ???????? "???????" ? ???? ??? ???? Errorlog. ???? ?????? ??? ??? ????? ?? ?????? ??? ????? SQL Server (??? ???? ??????? ?????? Sql60\Log ?? ?????? Mssql\Log) ".

?? ????? ????? ????? ????? ???? ??? ??? ????? ?????? errorlog:

   initdata: suballocation for buffer pages failed (%d bytes requested)
				


?? ????? ????? tempdb ?? RAM ???? ???? ??? ????? ?????? ????? ??????:

   Clearing temp db
   udactivate(IN_RAM): Operating system error 8(Not enough storage is
   available to process this command.) encountered
   Device activation error. The physical filename 'IN_RAM' may be incorrect
   crdb_tempdb: Unable to move tempdb into RAM; RAM device doesn't exist,
   cannot be created, or doesn't have enough space for tempdb
				


???? ??????? ??????? ??? ????? SQL Server ?? ????? ???????? sp_configure ???? ???? ?????? ??? ??? ????? ???? MSSQLServer ???????:

  1. ???? ???? ??????? ??? ??????. ???? -c sqlservr -f ???? ????? SQL Server ?? ??? ????? ???? ??????.

    ??? ??? ????? ??? ????? ?????? ?? ??? ???????? ?????? ? ???? ????? ????????? ??????? ??? ???????. ??? ????? ????? ?????? ??? ?????? "?????: ????? ????????? autoexec ????" ? ???? ?????? ??? ??????? ISQL/w ??????? ???????.
  2. ???? ?? ??? ?? ?? ????? SQL Executive ? ???? ????? ???? ?? ????? ?????? ??? SQL Server ??? ??? ?????? ???? ??????? ISQL/w ??????. ???? ??? ??????? ?? ??????? ???? ??? ?????? ?? ????? ?????? ?? ????? ???: ????? ??????? SQL SQL Executive ? MSDTC ? ???? SQL ? ?????? ?????? ? Systems Management Server ? ArcSrv ???????? ???????. ?? ???? ???? ??? ????? ?? ????? ??? ????? ?????; ????? ?????? ????? ??????? ?????? ?? ??? ??? ????? ????? ????? ????? SQL. ??? ?? ??? ????? ??? ??????? ??? ?? ????? ?? ????? ??? ????? ??????? ???????:
    msg 4002 ? 14 ??????? 1 ???? ???? Microsoft SQL Server? ??? ????? ?????? ?? 0 ????? DB: ????? ???? ??? ?????
  3. ?? ISQL/w ??????? sp_configure ?????? ??????? ??????? ?? tempdb ?? RAM. ??? ???? ??????? ????? ????? ?????? ??? ???:
          sp_configure memory, 8192
          go
          sp_configure tempdb, 0
          go
    						
  4. ?? ?????? ????? ????? ????? ????????? ??? ?? ???? ?? ?????? ??????:
          reconfigure with override
          go
    						
  5. ????? ??? SHUTDOWN.
  6. ??? ????? ???? MSSQLServer; ??? ?? ????.
????? ????? ??????? ??? ??????? ??????? ?? ??? ????? ?????? ???? ?? ???? ????? ??????? ?? SQL Server ????? ??? ??????? ??????? sp_configure ????. ??? ???? ??????? ????? ??????? ??????? ??????? ?? ??? ??????? ??? ????? ????? ??????? ?????? ??????? ????? ????.

??????: ??? ????? ?????? ?? sqlservr - c-f ???? ??? tempdb ??? 2 ???????? ??? ?????? ?????????. ???? ????? tempdb ??? ??????? ?????? ??? ?????? ?????? ??? ????? ????? ?????.

???????

???? ???????: 173090 - ????? ??? ??????: 04/????/1425 - ??????: 4.0
????? ???
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
????? ??????: 
kbmt kbhowto kbinfo kbtshoot KB173090 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????173090
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

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

 

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