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?
http://support.microsoft.com/kb/314515/EN-US/
http://www.informit.com/articles/article.asp?p=331402
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
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
]]>