SQL Server 2005 Log shipping

  • I thought I could retrieve data from the Standy/readonly database in log shipping; I seem to not be able to run a select on a table of the secondary database. Any advice would be helpful.

  • What is the status of your standby database now? Does it say it is in recovery?

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply