Thank you.

TDE enabled on that database.

Is TDE will effect the compression size?

Thank you guys

Thanks you.

Yes. Scheduled through the sql job agent

But needs to move the getdate()-2 backup files only. Not everything

Thank you

I opened the maintenance plan to edit but I didn't see file system task there.

I am aware that in the normal SSIS packages we have the file system task but...

How to find the trace flag 2371 is enabled or not in our environment?

Yes

I verified the backup is not completed. Now the problem resolved

Ok. Thank you

Hi Lempster,

To give you some more clarification, why I am using SSIS package

Currently the backups are residing in one server but database has to restore in another server.

I have...

2008r2 enterprise edition

Thank you

Thank you. It is working

The Index is system generated one.

It gave me below syntax

ALTER TABLE [dbo].[Test] DROP CONSTRAINT [UQ__Test__BED14FEE58EB02C0]

GO

ALTER TABLE [dbo].[Test] ADD UNIQUE NONCLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...

Thanks you

Here my concern is if I gave public server role and dbo owner for some databases, they can't see job history or they can't create maintenance plans