question

SQL8 avatar image
SQL8 asked

Proper Steps to set Log Shipping ?

Hi, Can anyone provide me proper steps of Log Shipping? How can I set Log Shipping? Thanks,
log-shipping
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
Cyborg avatar image
Cyborg answered
Start from here [Log Shipping MSDN Lib][1] [1]: http://msdn.microsoft.com/en-us/library/bb895393.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Blackhawk-17 avatar image
Blackhawk-17 answered
In a nutshell Log Shipping is: - Back up source - Restore as recovering on destination - Create SQL Agent jobs to do the following: 1. BACKUP Transaction Logs on source 2. COPY .TRN files to destination 3. RESTORE .TRNs with no recovery Depending on your version of SQL Server and your environment you can either use the SSMS GUI to achieve this or hand-code scripts.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Leo avatar image
Leo answered
try this website [Step By Step Log Shipping][1] [1]: http://alexsdba.spaces.live.com/blog/cns!F86565E81CD9BC16!182.entry
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.