Is there a way to ensure Transaction Log backups are not overwritten, and contain timestamps within the filename?
説明
Is there a way to ensure Transaction Log backups are not overwritten, and contain timestamps within the filename?
対策
In the Maintenance Plan, select the option 'Create unique media' at the time of taking the .TRN backups. Once this is set, the backup files are generated with timestamp attached to the filename.
