Monday, February 20, 2012

msdb and log shipping question

Hi,
We have set up an log shipping for DatabaseA between Server1 and Server2.
Now that log shipping was canceled and the DatabaseA in Server2 was also
deleted.
Is there any info still kept in the Server2 regarding to the log shipping
and DatabaseA?
I built a new log shipping plan but it was no good cause the transaction
didn't copy to the Server2, while other log shipping for other databases
were OK.
Thanks for help.
JasonHi Jason
Have you looked at http://msdn2.microsoft.com/en-us/library/ms187045.aspx
John
"Jason Huang" wrote:
> Hi,
> We have set up an log shipping for DatabaseA between Server1 and Server2.
> Now that log shipping was canceled and the DatabaseA in Server2 was also
> deleted.
> Is there any info still kept in the Server2 regarding to the log shipping
> and DatabaseA?
> I built a new log shipping plan but it was no good cause the transaction
> didn't copy to the Server2, while other log shipping for other databases
> were OK.
> Thanks for help.
>
> Jason
>
>|||If you did not remove the Log Shipping according to the procedure then the
jobs of old Log Shipping must be left in the Jobs node under SQL Server
Agent. You better purge them.
After deletion of the DatabaseA from the Server2, did you restore a copy of
the DatabaseA on the Server1 on Server2 in a STANDBY or NORECOVERY recovery
state?
You can check the history of the jobs that are created for the new Log
Shipping to find the exact error. There are three jobs created for Log
Shipping. One of them is for backing up the transaction log on the primary
server and the second is to copy it to some place and the last one is to
restore that copied transaction log file to the secondary server. Check
their job histories accordingly to find a track of the error.
--
Ekrem Önsoy
"Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
news:OhOaSWbTIHA.4272@.TK2MSFTNGP06.phx.gbl...
> Hi,
> We have set up an log shipping for DatabaseA between Server1 and Server2.
> Now that log shipping was canceled and the DatabaseA in Server2 was also
> deleted.
> Is there any info still kept in the Server2 regarding to the log shipping
> and DatabaseA?
> I built a new log shipping plan but it was no good cause the transaction
> didn't copy to the Server2, while other log shipping for other databases
> were OK.
> Thanks for help.
>
> Jason
>

No comments:

Post a Comment