March 1, 2015 at 11:07 pm
Hi Experts,
In always on docs in msdn they mention only about backup of secondary.. Can anyone please explain me the backup of primary or how logs are managed in primary database. My doubt is a normal database in full recovery mode the log file will grow if we didnt take proper log backup,how the same is managed in primary in Always On.
TIA
March 2, 2015 at 7:57 am
A backup log command on a secondary replica will truncate the log as necessary on the Primary. This link details the following
SQL Server Books Online
To back up a secondary database, a secondary replica must be able to communicate with the primary replica and must be SYNCHRONIZED or SYNCHRONIZING.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2015 at 6:02 am
Thanks a lot Perry
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply