SQL Server 2005 Express Edition ɵ¹Ïʽ°²×°
ÓÉÓÚ×î½üÒªÓõ½´ò°üSQL Server 2005 Express Edition £¬ÓÉÓÚÔÚ°²×°¹ý³ÌÖÐÐèÒªÉèÖúܶණÎ÷¡£´øÀ´ºÜ¶àµÄ²»±ã£¬ÓÚÊÇÔÚÍøÉϺÍMSDNÕÒÁ˺þÃÖÕÓÚÕÒµ½°ì·¨ÁË ^_^
ÎÒÓõÄÊÇÅú´¦ÀíÀ´ÊµÏֵģ¬ºÃÁËÖ±½ÓÌù´úÂë
CLS
@ECHO OFF
ECHO.
ECHO ===============================================================
ECHO ¿ªÊ¼°²×° SQL SERVER 2005 EXPRESS
ECHO Çë²»Òª¹Ø±Õ´Ë´°¿Ú,µÈ´ý°²×°¹ý³Ì½áÊø......
ECHO ===============================================================
start /wait setup.exe /qn ADDLOCAL=ALL REINSTALLMODE=O INSTANCENAME=MSSQLSERVER SECURITYMODE=SQL SAPWD=XXXXXX SQLBROWSERAUTOSTART=1 DISABLENETWORKPROTOCOLS=2
ECHO ===============================================================
ECHO Enabling SQLServer default instance port 1433
netsh firewall set portopening TCP 1433 "SQLServer"
ECHO ===============================================================
ECHO Enabling Dedicated Admin Connection port 1434
netsh firewall set portopening TCP 1434 "SQL Admin Connection"
ECHO ===============================================================
ECHO Enabling conventional SQL Server Service Broker port 4022
netsh firewall set portopening TCP 4022 "SQL Service Broker"
ECHO ===============================================================
ECHO Enabling Transact-SQL Debugger/RPC port 135
netsh firewall set portopening TCP 135 "SQL Debugger/RPC"
ECHO ===============================================================
ECHO Enabling SSAS Default Instance port 2383
netsh firewall set portopening TCP 2383 "Analysis Services"
ECHO ===============================================================
ECHO Enabling SQL Server Browser Service port 2382
netsh firewall set portopening TCP 2382 "SQL Browser"
ECHO ===============================================================
Ïà¹ØÎĵµ£º
DUMP TRANSACTION testdb WITH NO_LOG
BACKUP LOG testdb WITH NO_LOG
DBCC SHRINKDATABASE(testdb ......
ÎÒÔÚʹÓÃPL/SQLʱ£¬µã»÷ij¸ö×Ö¶ÎÅԱߵÄС°´Å¥Ï£Íûµ¯³ö±à¼´°¿Úʱ£¬PL/SQLÌáʾ“ÎÞЧµÄ´°¿Ú¾ä±ú”¡£Ò»Ö±²»Ã÷°×ÊÇÔõô»ØÊ£¬ºóÀ´baiduÁËÏ£¬²ÅÖªµÀÕâ¸ö¹¦ÄܺÍwindowsµÄprint spooler·þÎñÓйء£Æô¶¯¸Ã·þÎñ¾Í¿ÉÒÔÁË¡£ ......
·½·¨1£º
Ò»¡¢ÕÒÒ»ÕÅSQL server·þÎñÆ÷°æ¹âÅÌ£¬ÔÚ¹âÅÌÉÏÕÒµ½Ä¿Â¼“MSDE”²¢½øÈ룬ÔËÐÐSETUP.EXEÎļþ£¬²¢°´ÕÕ³ÌÐòÒªÇó½øÐа²×°¡£°²×°Íê³ÉÖØÐÂÆô¶¯¼ÆËã»ú¡£
¶þ¡¢ÔËÐйâÅÌÖеģ¬AUTORUN.EXEÎļþ£¬»òÈùâÅÌ×Ô¶¯ÔËÐУ¬´ò¿ª°²×°½çÃæºó£¬
µã»÷“°²×°SQL server 2000×é¼þ£¨C£©”-->“°²×°Êý¾Ý¿â·þÎñÆ ......
Ìá¸ßÊý¾Ý¿âSQLÓï¾ä²éѯËٶȵö·½·¨
1¡¢³ÌÐòÖУ¬
±£Ö¤ÔÚʵÏÖ¹¦ÄܵĻù´¡ÉÏ£¬¾¡Á¿¼õÉÙ¶ÔÊý¾Ý¿âµÄ·ÃÎÊ´ÎÊý£»
ͨ¹ýËÑË÷²ÎÊý£¬¾¡Á¿¼õÉÙ¶Ô±íµÄ·ÃÎÊÐÐÊý,×îС»¯½á¹û¼¯£¬´Ó¶ø¼õÇáÍøÂ縺µ££»
Äܹ»·Ö¿ªµÄ²Ù×÷¾¡Á¿·Ö¿ª´¦Àí£¬Ìá¸ßÿ´ÎµÄÏìÓ¦ËÙ¶È£»
ÔÚÊý¾Ý´°¿ÚʹÓÃSQLʱ£¬¾¡Á¿°ÑʹÓõÄË÷Òý·ÅÔÚÑ¡ÔñµÄÊ×ÁУ»
Ëã·¨µÄ½á¹¹¾¡Á¿¼òµ¥ ......