InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 12:23:00 GMT20http://www.sqlservercentral.com/Forums/Topic1421175-1549-1.aspxCan you post a screenshot of what you see?To check the settings for a log shipped database use the followingagainst the primary[code="SQL"]exec sp_help_log_shipping_primary_database 'primarydb'[/code]against the secondary [code="SQL"]exec sp_help_log_shipping_secondary_database 'secondarydb'[/code]Mon, 18 Feb 2013 09:18:14 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1421175-1549-1.aspxquery the logshipping tables in msdbMon, 18 Feb 2013 07:09:41 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1421175-1549-1.aspxHi 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 clueMon, 18 Feb 2013 07:08:52 GMTOnlyOneRJhttp://www.sqlservercentral.com/Forums/Topic1421175-1549-1.aspxThen something isnt right in the config.Attach a screen shotMon, 18 Feb 2013 06:32:53 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1421175-1549-1.aspx[quote][b]anthony.green (2/18/2013)[/b][hr]Ensure DB is set to full recovery.Click enable this primary check box,Click backup settingsGive it a network pathGive it a local pathGive it the right time frame and schedules etcClick ok[/quote]Anthony, I am not able to click OK, its disabled.... after the above steps...Mon, 18 Feb 2013 06:31:46 GMTOnlyOneRJhttp://www.sqlservercentral.com/Forums/Topic1421175-1549-1.aspxEnsure DB is set to full recovery.Click enable this primary check box,Click backup settingsGive it a network pathGive it a local pathGive it the right time frame and schedules etcClick okClick AddClick ConnectConnect to secondary serverGive it a secondary dbSelect the correct initializ methodGive it the copy directory and time frameGive it the right restore settingsClick okGive it the right monitor settings --OptionalClick OKMon, 18 Feb 2013 06:24:17 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1421175-1549-1.aspxI 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:Mon, 18 Feb 2013 06:12:17 GMTOnlyOneRJ