April 6, 2014 at 5:06 pm
I took a manually log backup and missed a folder name in the path.
to disk = "d:\folder\folder2\log.trn" instead of "d:\folder\folder2\folder3\log.trn"
If I movethe file to it's correct location (using windows explorer) is it safe to update the physical_device_name column within the backupmediafamily table?
Or is there a different/standard way to do this?
I don't want to just move it and break the log chain... nor do I want to run a full backup at the moment.
April 6, 2014 at 9:48 pm
Your backup chain goes by information (the LSNs) that is within each header of the physical backup file (full, differential, or log).
The information on the database/log backups written to the msdb backup tables have nothing to do with your backup chain. You can simply move the backup file to the correct folder you wish.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 6, 2014 at 10:02 pm
Thanks.
April 6, 2014 at 11:06 pm
My suggestion; do not change/update any thing on system table/database.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply