April 7, 2009 at 4:09 am
hi all,
i have configured log shipping, because of schedule job duration is oneminute, it is not able to restore the log, i have removed the log shiping configuration. but still the stand by database is in readonly/standby how can i remove this to get previous status.
🙂
April 7, 2009 at 4:30 am
because of schedule job duration is oneminute, it is not able to restore the log, i have removed the log shiping configuration
You can change the log restoration time.No need to delete the entire log-shipping configuration for this.
i have removed the log shiping configuration. but still the stand by database is in readonly/standby
After removing log-shipping through wizard in primary server,you have to delete the standby/readonly secondary database manually.
Also , the secondary database' details in the log_shipping system tables in msdb need to be removed.For this go through
sp_delete_log_shipping_primary_secondary (on primary)
sp_delete_log_shipping_secondary_database (on secondary).
April 7, 2009 at 5:35 am
vrabhadram (4/7/2009)
hi all,because of schedule job duration is oneminute, it is not able to restore the log, i have removed the log shiping configuration.
Job schedule duration has nothing to do with restoration. If an instance of job schedule is running, even if restore job is schedule to run for every 1 minute next instance will not run as previous schedule is still running.
As you mentioned it is not able to restore the log, how can you say that are there any errors.
Can you post the errors if any from the restore job history.
but still the stand by database is in readonly/standby how can i remove this to get previous status.
on secondary server the database either it will be in restoration state or standby state. What do you mean by previous state?
April 7, 2009 at 9:27 pm
hi,
thanks,
how can i remove the standby mode.
🙂
April 7, 2009 at 10:48 pm
HI,
I've configured log shipping. but restoration of log giving error.
Message:
Executed as user: INSTANCE\SYSTEM. The step failed.
🙂
April 7, 2009 at 10:59 pm
Pls post the detailed error description.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply