Yes well noted and conveyed the same to business and application owners. They are well are of the repercussions and will take a call on this. Thank you all for...

Yes that right Jeff. When Phil replied back with solution, I was well aware of it. These are very old records which business wants to erase before 2006 year. I...

Thank you Phil

So How can I overcome this. How can i delete the older data on journal table.

/****** Object: Trigger [dbo].[JournalInsteadOfDelete] Script Date: 2/26/2025 7:46:21 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

Create TRIGGER [dbo].[JournalInsteadOfDelete]

ON [dbo].[Journal]

INSTEAD OF DELETE

AS

BEGIN

SET NOCOUNT ON;

Insert into JournalDeleteAudit (journalRecId,journalTypeName,executedOn,parentRecId,userName,c.client_net_address)

select d.RecID,d.JournalTypeName,GETDATE(),d.ParentRecID,CURRENT_USER,c.client_net_address

from deleted d

cross join sys.dm_exec_connections c

where...

Yes there is a trigger

Yes thats right both are not the same

After deletion of files it says rows affected and when i search for the particular record it shows up the record.

After deleting it says rows affected

Yes it completed without errors and I can see the last modified date is July 2018.

The firewalls and ports are open. I tried HADR resume and got the below error message
Msg 35242, Level 16, State 16, Line 10
Cannot complete this ALTER DATABASE <database-name>...

Its an existing database Im trying to join. The cluster and listener is up. Yes the database was restored with no recovery and quorom is up and running.

Yes the test connection is successful. The same linked server i created on other server and it works fine. What kind of permission should i check upon ?

John,

I have the backup script with necessary fields that I need. I am just wondering how to import it in SSIS and get the information from all 100 servers.

I need the backup information from 100 servers on my domain like FULL, Incremental, Log,start date and finish date and how to make into SSIS ?