rem ECHO SP_ADDUMPDEVICE 'DISK',>>%dbbak_dir%FULL_restore_test.sql
rem ECHO '%F_filename%', >>%dbbak_dir%FULL_restore_test.sql
rem ECHO '%dbbak_dir%%F_filename%.bak'; >>%dbbak_dir%FULL_restore_Amino.sql
rem ECHO go >>%dbbak_dir%FULL_restore_test.sql
ECHO restore DATABASE %A_Database_Name% >>%dbbak_dir%FULL_restore_test.sql
ECHO from DISK = '%dbbak_dir%%F_filename%.bak' >>%dbbak_dir%FULL_restore_test.sql
echo with move 'test_Data' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\test_data.mdf',>>%dbbak_dir%FULL_restore_test.sql
echo move 'test_log' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\test_log.ldf',>>%dbbak_dir%FULL_restore_test.sql
ECHO norecovery >>%dbbak_dir%FULL_restore_test.sql
rem ECHO SP_ADDUMPDEVICE 'DISK',>>%dbbak_dir%FULL_restore_test.sql
rem ECHO '%F_filename', >>%dbbak_dir%FULL_restore_test.sql
rem ECHO '%dbbak_dir%%L_filename.trn'; >>%dbbak_dir%FULL_restore_test.sql
rem ECHO go >>%dbbak_dir%FULL_restore_test.sql
ECHO restore log %A_Database_Name% >>%dbbak_dir%FULL_restore_test.sql
ECHO from DISK = '%dbbak_dir%%L_filename.trn' >>%dbbak_dir%FULL_restore_test.sql
ECHO go >>%dbbak_dir%FULL_restore_test.sql
ECHO .
REM isql.exe path
SET iSQL_PATH=C:\Program Files\Microsoft SQL Server\80\Tools\Binn\
REM Database user name and password
SET DBUser=user
SET DBpassword=1111111
ECHO restore DATABASE
"%iSQL_PATH%isqlw.exe" -d %A_Database_Name% -U %DBUser% -P %DBpassword% -i "%dbbak_dir%FULL_restore_Amino.sql" -o "%dbbak_dir%result_Amino.txt"
echo .
REM delete file
move /y %dbbak_dir%FULL_restore_test.sql %logbak_dir%
move /y %dbbak_dir%result_test.txt %logbak_dir%
echo .
[ Last edited by creda on 2009-1-7 at 17:18 ]作者: creda 时间: 2009-1-8 17:59 居然没人理会