Thanks. But I did try to run it. Here is the reponse from
File 'cts_data' was only partially restored by a database
or file restore. The entire file must be successfully
restored before applying the log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
the cts_data is the data file of the database. Many thanks
>RESTORE DATABASE <databasename>
>SQL Server FAQ at
>> I have a problem that the test db server box crashed
>> it is in th emiddle of restoring. After the box been
>> rebooted, the database is constantly in loading status
>> several hours. The size of DB is about 1 GB. I don't
>> backup of this DB. Do I have to wait till DB been
>> recovered ? How long it would take to recover ? If not,
>> how could change the status of DB to normal like suspend
>> DB status ? I do need get some data and SPs from this
>> Many thanks.