How can we help you today? How can we help you today?

Log Shipped Database left restoring

I am trying to set up log shipping and have the following problem. The log is copied and restored, and move into the processed folder. If I execute RESTORE DATABASE <name> WITH RECOVERT it will go into an operational state. The problem is that after a log is restore it stays in a restore state, and doesn’t go into a Standby/Readonly state. Anyone else seen this, or have any ideas of what I may be doing wrong?
simmonsj_98
0

Comments

2 comments

Sort by
  • petey
    If you used the SQL Backup GUI to set up your log shipping process, then in step 3, you have the option to set the destination database to read-only mode, in the 'Destination database restore options' section. The default option is non-operational.

    If you have already set up the log shipping process, then on the secondary server, you can edit the restore job, and edit the restore process to use the STANDBY option e.g.

    from

    EXEC master..sqlbackup '-sql "RESTORE LOG ... WITH ... NORECOVERY ..." '

    to

    EXEC master..sqlbackup '-sql "RESTORE LOG ... WITH ... STANDBY = [g:\AdventureWorks.und] ..." '
    petey
    0
  • simmonsj_98
    I thought I set it to readonly on step 3, but I gusee I didn't. Recreated the job making sure it was set, and it is working.
    simmonsj_98
    0

Add comment

Please sign in to leave a comment.