restore database on SQL Server 6.5

Hi,
I restore a database using a 3rd party software. The
restore job was cancelled but the process "loading
database" is still in the output of "sp_who". I could not
kill it. Do I have to reboot the server to get rid of it
or I can start a job to continue to restore this database?
Thanks for help,
Hi,
Try STOP and START the MSSQL Server service. After that start the Loading of
database again from ISQL_W.
LOAD database <dbname> from disk='c:\backup\dbname.DMP' with stats=10
Note: stats=10 will show the percentage of load completed.
Thanks
Hari
MCDBA
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1d83601c453e7$425a6e30$a401280a@.phx.gbl...
> Hi,
> I restore a database using a 3rd party software. The
> restore job was cancelled but the process "loading
> database" is still in the output of "sp_who". I could not
> kill it. Do I have to reboot the server to get rid of it
> or I can start a job to continue to restore this database?
> Thanks for help,