asked on

T-SQL for Delete backups

How to write T-SQL to compare two existing sql backups (.bak) in a given location and delete old backups?
This is sql server 2016?

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Hi Ajay,

Let me try and get back to you.

ASKER

Mark Yes. We already configured maintenance plans . But this requirement is for some testing.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

What do you want to compare?
If they are the same backup file? Then check the file names, sizes and date and time.

Vijay, please let us know if this issue has been solved or if you need further help.

ASKER

Thank you very much Virot

ASKER

Thank you Vitor.