Our backup script doesn't have an INIT specified and the job that moves our backup failed over the weekend. Then when the next backup happened, it appended to the set and our server ran out of space.
So I'm going to specify an INIT in the WITH section, but I can't find anything that says if the INIT with a COPY_ONLY uses the retention settings for the server, or since it's a COPY_ONLY, it just overwrites any existing script.
Do I need to specify a RETAINDAYS=1 in the or can I just add the INIT?
I also see that RETAINDAYS is going away, is EXPIREYDATE the new option?