I would try to combine all the Log Shipping Jobs in on Job.

The result should be that one Job after an other is executed and they don’t run parallel....

Try running the SQL Server Agent with an Account which has sysAdmin Access on both DBs and Modify Access to all the involved Directorys

Born in Vorarlberg and working in Leoben,Steiermark

Austria, Central Europa

I'm Operational IT

I am a DBA (MySQL, MSSQL), WebServer Manager, problem solver,...

And get every task none other can/like to do.

And each Problem, is a new challenge for me because i...

I'm also interested in this topic

CREATE TRIGGER [TDE_TR_LS]

ON ALL SERVER

AFTER CREATE_DATABASE

AS

--Get the Name of the DB and store it in @DBname

DECLARE @data XML

DECLARE @DBname nvarchar(max)

set @data =...