Sample Header Ad - 728x90

Can I regularly log ship from a source to a target, while running DML on the target?

0 votes
2 answers
57 views
I want to have two databases on separate severs. Let's call the databases Source and Target. Target is the reporting server copy of Source. Except for the changes caused by a stored procedure that I need to regularly run in Target, I want Source and Target to be identical and sync'd up roughly once a day. All of the data needed to create Source comes from the same server as Source. Is log shipping a suitable method to solve this problem? Or does my "I need to run a stored procedure that changes database Target" restriction completely rule that out?
Asked by J. Mini (1237 rep)
Jan 31, 2024, 08:58 PM
Last activity: Jan 31, 2024, 10:04 PM