August 18, 2015 at 1:02 pm
We have a database that does require a failover if something goes wrong. However, the data isn't important enough to require point of time recovery. Am I able to run t-log backups and then delete them immediately after with AG?
August 18, 2015 at 2:05 pm
You could just backup to NUL. This removes the step of deleting the log backups.
BACKUP LOG database_name TO DISK='NUL'
August 18, 2015 at 2:54 pm
This is a great tip, thanks.
August 19, 2015 at 2:07 pm
JoshDBGuy (8/18/2015)
We have a database that does require a failover if something goes wrong. However, the data isn't important enough to require point of time recovery. Am I able to run t-log backups and then delete them immediately after with AG?
The very nature of enabling HADR requires that log backups are available, what if you need to resync the secondary for any reason?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply