February 18, 2013 at 6:12 am
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
February 18, 2013 at 6:24 am
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
February 18, 2013 at 6:31 am
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
February 18, 2013 at 6:32 am
Then something isnt right in the config.
Attach a screen shot
February 18, 2013 at 7:08 am
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
February 18, 2013 at 7:09 am
query the logshipping tables in msdb
February 18, 2013 at 9:18 am
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