Log Shipping Issue

  • I was trying to set Log Shipping on the Test server, but some how it didnt work... so now when i am doing it from start, it does not allow me to prcoeed.. like when i set the primary server & then go in Backup settings.. The OK button is deactivated..

    Well can anyone really help me with setting this on test environment... i tried Google step by step links but was not able to implement..

    I am sure that i am missing some points... but please help..:w00t:

    ************************************
    Every Dog has a Tail !!!!! :-D

  • Ensure DB is set to full recovery.

    Click enable this primary check box,

    Click backup settings

    Give it a network path

    Give it a local path

    Give it the right time frame and schedules etc

    Click ok

    Click Add

    Click Connect

    Connect to secondary server

    Give it a secondary db

    Select the correct initializ method

    Give it the copy directory and time frame

    Give it the right restore settings

    Click ok

    Give it the right monitor settings --Optional

    Click OK

  • anthony.green (2/18/2013)


    Ensure DB is set to full recovery.

    Click enable this primary check box,

    Click backup settings

    Give it a network path

    Give it a local path

    Give it the right time frame and schedules etc

    Click ok

    Anthony, I am not able to click OK, its disabled.... after the above steps...

    ************************************
    Every Dog has a Tail !!!!! :-D

  • Then something isnt right in the config.

    Attach a screen shot

  • Hi Anthony,

    There is One Log shipping Done on the Testing server, which is working fine..

    As i can see the LS jobs in SQL Server Agent..

    Now if i want to view the entire steps from scrath that how is it implemented then how do i do that??? any clue

    ************************************
    Every Dog has a Tail !!!!! :-D

  • query the logshipping tables in msdb

  • Can you post a screenshot of what you see?

    To check the settings for a log shipped database use the following

    against the primary

    exec sp_help_log_shipping_primary_database 'primarydb'

    against the secondary

    exec sp_help_log_shipping_secondary_database 'secondarydb'

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 7 posts - 1 through 6 (of 6 total)

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