I have set up Log Shipping on my production server to ship the logs to a
backup server. But the database in the backup server is always in the
loading state. It have "read only" option set on its properties that way I
can still run quires on the DB, but it always says (loading). Can anybody
help!!!
Thanks,
-Pavan
Never Mind changed it from "No recovery Mode" to 'Standby" mode and it works
fine now
"Pavan" <seattlemcse@.online.hotmail.com> wrote in message
news:#1SNgvnzEHA.3548@.TK2MSFTNGP09.phx.gbl...
> Hello All,
> I have set up Log Shipping on my production server to ship the logs to
a
> backup server. But the database in the backup server is always in the
> loading state. It have "read only" option set on its properties that way I
> can still run quires on the DB, but it always says (loading). Can anybody
> help!!!
>
> Thanks,
> -Pavan
>
|||A few days ago you posted that your log shipping database is stuck in loading state and you were unable to run reports from that server. You mentioned changing from no recovery to standby and all is well. How did you go about doing that ? When I initially setup log shipping I set everything to standby and even now the maintenance plans show standby, yet my DB still show loading. Your help is GREATLY appreciated !!
Quote:
Hello All,
I have set up Log Shipping on my production server to ship the logs to a
backup server. But the database in the backup server is always in the
loading state. It have "read only" option set on its properties that way I
can still run quires on the DB, but it always says (loading). Can anybody
help!!!
Thanks,
-Pavan
No comments:
Post a Comment