Log Shipping : MSG 927 Database cannot be opened It is Restoring state -- Getting this Error in STANDBY/READONLY Mode (Network Steve Forum)

Log Shipping : MSG 927 Database cannot be opened It is Restoring state -- Getting this Error in STANDBY/READONLY Mode

we have setup a log shipping For one database. we configured secondary server as STANDBY/READONLY mode.

When we are trying to run a select query in secondary server is giving me error message as

MSG 927 Database cannot be opened . It is in middle of restore

But the state of database as per SSMS object explorer it is STANDBY/READONLY (Even after refreshing the database).

so can any one tell me the reasons behind this Error caused

September 9th, 2015 8:15am

Few things to check are

What is the status of your last restore job ? If this fails for some reasons there are chances that the Db can be in a loading state.
Query the sys.database and log shipping tables to see the state of Secondary database
Check the errorlog

September 9th, 2015 9:07am

select * from sys.databases share output..

September 9th, 2015 10:12am

Please go through the link.

https://www.mssqltips.com/sqlservertip/3574/change-sql-server-log-shipped-database-from-restoring-to-standby-readonly/

September 10th, 2015 1:37am

This topic is archived. No further replies will be accepted.