March 10, 2023 at 12:12 pm
Dear Friends,
I have setup log shipping on one of the servers. The setup was smooth but what I see is that Log shipping doesn't occur for those database that have 'No Recovery' mode option enabled (and which is the default)..But the databases that are set on the 'StandBy/Read Only' mode, the log backup/copy and restore occurs as per the job schedules...the ones that have 'no recovery' synchronize only when I run the jobs manually..Can any body shed some light on this..If we have to do manually, what is the point in setting the 'Schedules' for the jobs...Thank you in advance.
March 10, 2023 at 2:56 pm
How are you determining that those databases are not synchronising?
Are any of the jobs failing? Does the monitor job fail warning that a backup/copy/restore hasn't happened within the allotted threshold time?
Are you seeing any errors/warnings etc anywhere?
Have you checked the log shipping tables in the MSDB database to see what it thinks is going on?
March 13, 2023 at 5:00 pm
Any check done which is recommended by Ant-Green?
Regards
Durai Nagarajan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply