Perry Whittle (3/5/2015)
on the 2 servers that are not working as expected please run the following query.
select differential_base_lsn, differential_base_timefrom sys.master_files
where database_id = DB_ID('yourdb')
and type = 0
group by differential_base_lsn, differential_base_time
If the result is the same on the primary and the secondary,
- take a differential backup on the primary
- disable the LS agent backup job on the primary
- disable the copy and restore jobs on the secondary
- restore the differential to the secondary
- Once done re enable any jobs
- create a new table
- run all jobs and check object exists
Thank you so much for being patience but this is what I did.
Took the differential backup on the Primary
Disable backup job on Primary
Disable copy job and restore job on secondary
On secondary server, when I try to restore by expanding DB, task and restore, I only see 1 option (transactional log) highlighted. Database and files and filegroups option are not highlighted.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]