SQL Server Performance

DB in a loading state

Discussion in 'SQL Server Log Shipping' started by jdl508, Jul 20, 2006.

  1. jdl508 New Member

    Hello,

    I have log shipping configured between 2 sql2000 Ent Ed servers. Everything seems to be copying and applying however the DB's on the standby server always seem to be in a loading state (next to the DB name in enterprise manager they display loading). I also get the IN LOAD error in the sql logs which after reading here I am deeming as normal. Is this normal? I'm assuming if I restore the most recent TRN log I will be up and running on the DB in questions but would like to verify this to be true.

    Thanks
  2. satya Moderator

  3. DavidASDF New Member

    restore database "your db name" from disk='your backup file' with standby

    -- David

    * Download SQL Server backup & restore ulities from databk.com

Share This Page