July 20, 2017 at 7:56 am
Hello All,
Quick question (hopefully): When implementing a maintenance plan for SQL Server 2012/2014, does the .diff backup type need to reside in the same folder as the .bak folder to a make the backup files valid?
The maintenance plan im looking at puts all the backup types, .trn, .diff, .bak in separate folders. I wanted to ensure that this method is correct for DR purposes.
Kind Regards,
Tom.
July 20, 2017 at 8:19 am
Tjbillybob - Thursday, July 20, 2017 7:56 AMHello All,Quick question (hopefully): When implementing a maintenance plan for SQL Server 2012/2014, does the .diff backup type need to reside in the same folder as the .bak folder to a make the backup files valid?
The maintenance plan im looking at puts all the backup types, .trn, .diff, .bak in separate folders. I wanted to ensure that this method is correct for DR purposes.
Kind Regards,
Tom.
It's fine to have the types separated out with the different folders. What folder the backup goes to doesn't affect the validity of the backup.
Testing by restoring the backups is how you would ensure the validity of the backups.
Sue
July 20, 2017 at 8:21 am
Thanks Sue for the fast response!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply