SQL Server Performance Forum – Threads Archive
Log shipping setup – copy transaction log
the system will perform full backup at 1 amthere will be some transactions started from 9 am
log shipping will be configured at 11:45am and the backup from 1am will be used
after the log shipping is configured, how the copy task run to make sure the transaction b/w 9am and 11:45am will be synchronized to stand by server ? the task of copying log will copy the lastest transaction log to standby server
or .. it will extract the transactions b/w the internal (9:00 – 9:15, 9:15 – 9:30 ) and copy the files to standby
If the full backup is performed and applied to secondary server, and then the log shipping will take care of schedule of log restore on secondary server. According to the log shipping schedule the log backups will be performed and restored. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
how about if the full backup is not the latest snapshot of the primary server?
The log restore will fail due to mismatch of LSN on full backup and log backup. I think you must need a refresh on log architecture of SQL SErver to know more about it.
Books online is your best pal. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>