View Single Post
Old 10th November 2004, 21:49   #8
bgosalci
Guest
 
Posts: n/a
OK, so the correct way of using nsExec::Exec command will be, as follows:

nsExec::Exec 'osql -E -S$ServerName\LA \
RESTORE DATABASE MyDatabase \
FROM DISK = $InstDir\MSDE 2000A\Backup\MyDatabase ' \
WITH RECOVERY, \
MOVE "MyDatabase_Data" TO "$InstDir\MSDE 2000A\MSSQL$LA\Data\MyDatabase.mdf", \
MOVE "MyDatabase_Log" TO "$InstDir\MSDE 2000A\MSSQL$LA\Data\MyDatabase.ldf" \
GO'

Yer or No

And by the way thank you very match to all, for all the help.
  Reply With Quote