å¯ä»¥ä½¿ç¨å½ä»¤net start sqlserver æsqlservr æ¥å¯å¨æå¡å¨ãå
¶ä¸net start sqlserver å½ä»¤ä¸å¸¦åæ°ï¼ä¸ä¹ç¸åºçå½ä»¤è¿ææåæå¡å¨å½ä»¤net pauseã 继ç»æå¡å½ä»¤net continueãåæ¢æå¡å¨å½ä»¤net stop çãsqlservr å½ä»¤æ¯è¾å¤æï¼å¯ä»¥å 带许å¤åæ°ãå
¶è¯æ³å¦ä¸æç¤ºï¼ sqlservr [-c] [-dmaster_path] [-f] [-eerror_log_path] [-lmaster_log_path] [-m] [-n] [-pprecision_level] [-sregistry_key] [-Ttrace#] [-v] [-x]
åæ°è¯´æå¦ä¸ï¼
-c
ææSQL Server ç¬ç«äºNT æå¡ç®¡çæ§å¶èå¯å¨ä½¿ç¨æ¤åæ°å¯ä»¥ç¼©çå¯å¨SQL Server
çæ¶é´ãä½æ¯ç¨å®ä¹åï¼å°±ä¸è½éè¿SQL Server Service Manager ænet ç³»åå½ä»¤æ¥æå
æåæ¢SQL Serverï¼ å¹¶ä¸å¨éåºæä½ç³»ç»åå¿
é¡»å
å
³éSQL Serverã
-dmaster_path
ææmaster æ°æ®åºçå
¨è·¯å¾ãå¨-d åmaster_path.ä¹é´æ²¡æç©ºæ ¼ã
-f
ç¨æä½é
ç½®å¯å¨æå¡å¨ã
-eerror_log_path
ææerror log æ件çå
¨è·¯å¾ãå¨-e åerror_log_path ä¹é´æ²¡æç©ºæ ¼ã
-lmaster_log_path
ææmaster æ°æ®åºçtransaction log æ件çå
¨è·¯å¾ãå¨-l åmaster_log_path ä¹é´æ²¡æ
ç©ºæ ¼ã
-m
ææç¨åç¨æ·æ¹å¼å¯å¨SQL Serverã
-n
ææä¸ä½¿ç¨Windows NT çç¨åºæ¥å¿æ¥ç»è®°SQL Server çäºä»¶ãå¦æ使ç¨äºæ¤åæ°ï¼
åæ好åæ¶ä½¿ç¨-e åæ°ï¼å¦åSQL Server äºä»¶å°±ä¸ä¼è¢«çºªå½ã
-pprecision_level
æædecimal ånumeric æ°æ®ç±»åçæé«ç²¾åº¦ãå¨-p åprecision_level ä¹é´æ²¡æç©ºæ ¼ã
precision_level åå¼èå´ä¸º1 å°38ã ä¸ç¨æ¤åæ°æ¶ï¼ç³»ç»é»è®¤ä¸º28ï¼ ä½¿ç¨æ¤åæ°èä¸ææ
å
·ä½ç²¾åº¦æ¶ï¼ç³»ç»è®¤ä¸ºæ¯38ã
-sregistry_key
ææè¦æ ¹æ®æ³¨å表ä¸registry_key ä¸çåæ°é项æ¥å¯å¨SQL Serverã
-Ttrace#
ææéSQL Server å¯å¨ä¸ä¸ªæå®çè·è¸ªæ è®°trace#ã 注æï¼-T 为大åã
-v
å¯å¨æ¶æ¾ç¤ºSQL Server ççæ¬å·ã
-x
ä¸ä½¿ç¨CPU ä¿¡æ¯ç»è®¡ã
温馨提示:答案为网友推荐,仅供参考