Results 1 to 2 of 2

Thread: database in loading state

  1. 07-31-2002, 04:50 PM #1
    r Guest

    database in loading state

    while loading the transaction log dump on a 'STANDBY' database the connection got terminated. as a result the database was marked 'LOADING' and inaccesible. i would like to know if there is a way to get the db out of this mode without having to reapply a full database dump.

    P.S. please ignore the previous two messages posted with the same subject line. i inadvertently pressed post twice. sorry for the spam.
    Reply With Quote Reply With Quote
  2. 08-01-2002, 07:59 AM #2
    Ray Miao Guest

    database in loading state (reply)

    Try sp_resetstatus or modify status in sysdatabases.


    ------------
    r at 7/31/2002 5:50:31 PM

    while loading the transaction log dump on a 'STANDBY' database the connection got terminated. as a result the database was marked 'LOADING' and inaccesible. i would like to know if there is a way to get the db out of this mode without having to reapply a full database dump.

    P.S. please ignore the previous two messages posted with the same subject line. i inadvertently pressed post twice. sorry for the spam.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules