by eugene li » Wed, 17 Jul 2002 20:31:31
I have a problem that the test db server box crashed when
it is in th emiddle of restoring. After the box been
rebooted, the database is constantly in loading status for
several hours. The size of DB is about 1 GB. I don't have
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 DB.
Many thanks.
EUgene
by Dinesh T » Wed, 17 Jul 2002 20:35:21
Try
RESTORE DATABASE <databasename>
WITH RECOVERY
Dinesh.
--
---
SQL Server FAQ at
www.tkdinesh.com
Quote:> Hi,
> I have a problem that the test db server box crashed when
> it is in th emiddle of restoring. After the box been
> rebooted, the database is constantly in loading status for
> several hours. The size of DB is about 1 GB. I don't have
> 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 DB.
> Many thanks.
> EUgene
by eugene li » Wed, 17 Jul 2002 21:08:44
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
again.
Eugene
>Try
>RESTORE DATABASE <databasename>
>WITH RECOVERY
>Dinesh.
>--
>---
>SQL Server FAQ at
>www.tkdinesh.com
>> Hi,
>> I have a problem that the test db server box crashed
when
>> it is in th emiddle of restoring. After the box been
>> rebooted, the database is constantly in loading status
for
>> several hours. The size of DB is about 1 GB. I don't
have
>> 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
DB.
>> Many thanks.
>> EUgene
>.
by Dinesh T » Thu, 18 Jul 2002 16:03:53
Did you lose the previous backup too? contact MS
PSS(http://support.microsoft.com)
Dinesh.
--
---
SQL Server FAQ at
www.tkdinesh.com
> 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
> again.
> Eugene
> >-----Original Message-----
> >Eugene,
> >Try
> >RESTORE DATABASE <databasename>
> >WITH RECOVERY
> >Dinesh.
> >--
> >---
> >SQL Server FAQ at
> >www.tkdinesh.com
> >> Hi,
> >> I have a problem that the test db server box crashed
> when
> >> it is in th emiddle of restoring. After the box been
> >> rebooted, the database is constantly in loading status
> for
> >> several hours. The size of DB is about 1 GB. I don't
> have
> >> 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
> DB.
> >> Many thanks.
> >> EUgene
> >.
I am trying to restore a database from a 2nd to last backup. When ever I
attempt to restore the database remains in the status of loading. It will
not go to operational mode until it recieves the latest backup. Does anybody
know if there is a configuration of the backup/restore that I am missing?
Thanks - Jay
2. FTP
4. SE 7.24.UC5 on Slackware Linux 7.1
6. macola to solomon conversion
7. Log shipping secondary DB status "(Loading)"
9. Restore Northwind DB leaves in loading status
10. DB never come back from loading status
11. Indexes going into DIRECT LOAD status
12. how delete database where status is loading
13. (Loading) Status on Database