Logshipping

Question

Post reply

Logshipping

jsmithadd

SSC Journeyman

Points: 93
More actions
September 20, 2011 at 11:13 pm

#244201

In logshipping,
What are we going to do to restore the correct Log ?
What are the sources for the log backups?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

http://msdn.microsoft.com/en-us/library/ms187103.aspx

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 2

Are you actually encountering a problem, or are you just trying to learn the ropes?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Ali Tailor Hall of Fame Points: 3769 More actions · Answer 3

jsmithadd (9/20/2011)
In logshipping,
What are we going to do to restore the correct Log ?
What are the sources for the log backups?

Configure the Primary database for Logshipping to restore the correct log.

The source of log backup is Primary database.

also look at the Muthukkumaran Kaliyamoorthy's reply.

Ali
MCTS SQL Server2k8

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

You could also take a look at this article

http://www.sqlservercentral.com/redirect/articles/75880/

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events