Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log Shipping Issue Expand / Collapse
Author
Message
Posted Monday, February 18, 2013 6:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
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..








************************************
Every Dog has a Tail !!!!!
Post #1421175
Posted Monday, February 18, 2013 6:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 2:37 AM
Points: 5,075, Visits: 4,834
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




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1421179
Posted Monday, February 18, 2013 6:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
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 !!!!!
Post #1421180
Posted Monday, February 18, 2013 6:32 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 2:37 AM
Points: 5,075, Visits: 4,834
Then something isnt right in the config.

Attach a screen shot




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1421181
Posted Monday, February 18, 2013 7:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 12:13 AM
Points: 258, Visits: 690
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 !!!!!
Post #1421205
Posted Monday, February 18, 2013 7:09 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 2:37 AM
Points: 5,075, Visits: 4,834
query the logshipping tables in msdb



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1421206
Posted Monday, February 18, 2013 9:18 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:15 PM
Points: 5,951, Visits: 12,822
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"
Post #1421261
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse