DB in a loading state | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DB in a loading state

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
Have you use STANDBY clause while restoring the database?
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
restore database "your db name" from disk=’your backup file’ with standby — David * Download SQL Server backup & restore ulities from databk.com