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 ?

So is it a problem with the code ?

Wow, it worked. 🙂

select count(*), AVG(CAST(datalength(embedded_data) AS BIGINT)) from task_attach where id_task_user in (

select id

from task_user

where task_type = 2

and date_begin >= CAST(CAST(DATEADD(DAY,-180,GETDATE()) AS DATE) AS DATETIME)

)

The output is

0, NULL

When i run the whole query below i get error. The subquery runs successfully.

Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to data type int.

select...

The sub query gets executed successfully.

Below script is of task_user

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[task_user](

[id] [uniqueidentifier] NOT NULL,

[id_acs_user] [uniqueidentifier] NOT NULL,

[task_type] [int] NOT NULL,

[name] [nvarchar](15) NOT NULL,

[status] [smallint] NULL,

[xoperation] [ntext] NULL,

[xparameters] [ntext] NULL,

[xreport] [ntext]...

Yes ID column is primary key and ID_TASK_USER is foreign key with unique identifiers. Below is the script

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[task_attach](

[id] [uniqueidentifier] NOT NULL,

[id_task_user] [uniqueidentifier] NOT NULL,

[detail]...

Its foreign key. Unique identifier Not Null.

Yes I used COUNT_BIG and got the same error. Also I don't use any other expression.