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
