Log Shipping Issue

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Log Shipping Issue

Log Shipping Issue

Rate Topic

Display Mode

Topic Options

Author

Message

OnlyOneRJ

Posted Monday, February 18, 2013 6:12 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:02 AM
Points: 158, Visits: 443

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 !!!!!

Post #1421175

anthony.green

Posted Monday, February 18, 2013 6:24 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

OnlyOneRJ

Posted Monday, February 18, 2013 6:31 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:02 AM
Points: 158, Visits: 443

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

anthony.green

Posted Monday, February 18, 2013 6:32 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Then something isnt right in the config.

Attach a screen shot

Post #1421181

OnlyOneRJ

Posted Monday, February 18, 2013 7:08 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:02 AM
Points: 158, Visits: 443

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

anthony.green

Posted Monday, February 18, 2013 7:09 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

query the logshipping tables in msdb

Post #1421206

Perry Whittle

Posted Monday, February 18, 2013 9:18 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 5,201, Visits: 11,150

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" Wink

Post #1421261

« Prev Topic | Next Topic »

Permissions