November 1, 2011 at 8:43 am
I have created a log shipping strategy but its been awhile. Please confirm for me that you have to restore a full copy of the database to the server that will house the log shipping database. The log shipping database has to be an exact replica of the main database. If you only want to copy certain
portions of data then that would be replication.
Thanks,
November 1, 2011 at 8:54 am
You have to restore a full backup from the primary to the standby server and then all subsequent logs. The database needs to be restore with No recovery/Standby so that additional logs can be applied.
November 1, 2011 at 9:06 am
And yes, if yoou only wanted to restore 'certain' details, that would be transactional replication.
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 1, 2011 at 9:16 am
thanks to all of you for this confirmation. Your answers was what I was expecting.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply