I have followed the steps for Log Shipping in the "How to Perform SQL Server Log Shipping" article and am having a problem. The orginal DB is backed up fine, copied to backup server fine, and appears to be restored fine (based on file times and sizes) but the job finished the the database is stuck in (Loading) Mode. Here is my SP for the restore. --- CREATE PROCEDURE restore_database_backups AS RESTORE DATABASE database_name FROM DISK = 'data SQL ServerMSSQLStandbyStandbyDBBackup.bak' WITH DBO_ONLY, REPLACE, STANDBY = 'data SQL ServerMSSQLStandbyundo_StandbyDBBackup.ldf', MOVE 'Fakename_dat' TO 'data SQL ServerMSSQLDatafakename.mdf', MOVE 'Fakename_log' TO 'f:SQL2kLogsfakename.ldf' WAITFOR DELAY '00:00:05' EXEC sp_dboption 'Fakename', 'single user', true --- I changed the database name for this email, but you get the idea. If I try and go anything in query analyzer it will come back that this DB is only partically restored. Any Ideas? Thanks!