SQL Server 2000 绿色版

djCode 2011-05-18 03:41:33

在一台已经安装好的SQL 2000机器上，将以下代码Copy成一个bat文件执行即可，

生成的 C:\SQL 目录为SQL 2000绿色版文件。

最后进入C:\SQL\Binn目录中，执行 sqlservr.exe -c xsh -d C:\SQL\Data\master.mdf -l C:\SQL\Data\mastlog.ldf -e C:\SQL\Logs\ERRORLOG

echo off

echo Copy C:\Program Files\Microsoft SQL Server\MSSQL\Binn To C:\SQL
md C:\SQL
md C:\SQL\Binn

Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\atxcore.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\cmdwrap.exe" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\comnevnt.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\console.exe" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\dbghelp.dll" C:\SQL\Binn
echo Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\ftsetup.exe" C:\SQL\Binn, file not find
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Msdbi.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\mssdi98.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\mssql.mib" C:\SQL\Binn
echo Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\msvcp71.dll" C:\SQL\Binn, file not find
echo Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\msvcr71.dll" C:\SQL\Binn, file not find, SQL 2000 Enterprise exists.
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\odsole70.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\opends60.dll" C:\SQL\Binn
echo Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\opends80.dll" C:\SQL\Binn, file not find
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\replupd.exe" C:\SQL\Binn
echo Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Schema.txt" C:\SQL\Binn, file not find
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\semmap.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\semnt.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlagent.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlagent.exe" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlatxss.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlboot.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlcmdss.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\SQLCTR.H" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\SQLCTR.INI" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr80.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqldata.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqldiag.exe" C:\SQL\Binn
echo Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlftqry.dll" C:\SQL\Binn, file not find
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlimage.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlmaint.exe" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlmap70.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlrepss.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlresld.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlsnmp.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlsort.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlstbss.exe" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlsvc.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\ssmsad70.dll" C:\SQL\Binn
echo Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\ssmsgnet.dll" C:\SQL\Binn, file not find
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\SSmsLPCn.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\ssmsqlgc.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\SSmsRP70.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\SSmsSH70.dll" C:\SQL\Binn
echo Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\ssmssnet.dll" C:\SQL\Binn, file not find
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\SSmsVI70.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\SSnetlib.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\ssnmpn70.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\textcopy.exe" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\ums.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\vswitch.exe" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\w95scm.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xpadsi.exe" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xplog70.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xpqueue.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xprepl.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xpsqlbot.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xpstar.dll" C:\SQL\Binn
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\xpweb70.dll" C:\SQL\Binn

md C:\SQL\Binn\Resources

echo Copy C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033 To C:\SQL\Resources\1033
md C:\SQL\Binn\Resources\1033

Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\atxcore.rll" C:\SQL\Binn\Resources\1033
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\odsole70.rll" C:\SQL\Binn\Resources\1033
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\semmap.rll" C:\SQL\Binn\Resources\1033
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\Semnt.rll" C:\SQL\Binn\Resources\1033
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\sqlagent.rll" C:\SQL\Binn\Resources\1033
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\sqlatxss.rll" C:\SQL\Binn\Resources\1033
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\sqlcmdss.rll" C:\SQL\Binn\Resources\1033
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\sqlevn70.rll" C:\SQL\Binn\Resources\1033
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\sqlmaint.rll" C:\SQL\Binn\Resources\1033
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\sqlrepss.rll" C:\SQL\Binn\Resources\1033
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\sqlstbss.rll" C:\SQL\Binn\Resources\1033
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\sqlsvc.rll" C:\SQL\Binn\Resources\1033
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\xplog70.rll" C:\SQL\Binn\Resources\1033
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\1033\xpstar.rll" C:\SQL\Binn\Resources\1033

echo Copy C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052 To C:\SQL\Resources\2052
md C:\SQL\Binn\Resources\2052

Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\atxcore.rll" C:\SQL\Binn\Resources\2052
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\odsole70.RLL" C:\SQL\Binn\Resources\2052
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\semmap.rll" C:\SQL\Binn\Resources\2052
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\Semnt.rll" C:\SQL\Binn\Resources\2052
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\sqlagent.rll" C:\SQL\Binn\Resources\2052
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\sqlatxss.RLL" C:\SQL\Binn\Resources\2052
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\sqlcmdss.rll" C:\SQL\Binn\Resources\2052
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\sqlevn70.rll" C:\SQL\Binn\Resources\2052
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\sqlmaint.RLL" C:\SQL\Binn\Resources\2052
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\sqlrepss.rll" C:\SQL\Binn\Resources\2052
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\sqlstbss.rll" C:\SQL\Binn\Resources\2052
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\sqlsvc.rll" C:\SQL\Binn\Resources\2052
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\xplog70.rll" C:\SQL\Binn\Resources\2052
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\Resources\2052\xpstar.rll" C:\SQL\Binn\Resources\2052

echo Copy Success Binn.

echo Copy C:\Program Files\Microsoft SQL Server\MSSQL\Data To C:\SQL\Data
md C:\SQL\Data

Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf" C:\SQL\Data
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Data\mastlog.ldf" C:\SQL\Data
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Data\model.mdf" C:\SQL\Data
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Data\modellog.ldf" C:\SQL\Data
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdbdata.mdf" C:\SQL\Data
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\Data\msdblog.ldf" C:\SQL\Data

echo Copy Success Data.

md C:\SQL\Logs\
Copy "C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG" C:\SQL\Logs

echo Copy Success Logs.

echo ---------------------------------------------

echo execute "sqlservr.exe -c xsh -d C:\SQL\Data\master.mdf -l C:\SQL\Data\mastlog.ldf -e C:\SQL\Logs\ERRORLOG"

...全文