Log shipping - Require step by step procedure in SQL 2000

Question

Post reply

Log shipping - Require step by step procedure in SQL 2000

T.LOGANATHAN

SSC Veteran

Points: 298
More actions
September 28, 2007 at 6:19 am

#118840

Hi,
I had tried so many procedure for Log shipping in SQL 2000. Its happening source server only but not happens in the destination server- Need step by step procedure in SQL 2000 to help my schedules.
T.Loganathan

Viewing 15 posts - 1 through 15 (of 19 total)

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

devaraya Default port Points: 1455 More actions · Answer 1

Hi Loganathan,

I have a word document with me for log shipping. Give your mail id i will forward it to you .

Ramaa

T.LOGANATHAN SSC Veteran Points: 298 More actions · Answer 2

Hi Gouthami Putra Sathakarni,

My email id is logu.t@nic.in

Logut

devaraya Default port Points: 1455 More actions · Answer 3

Hi Loganathan,

ok.. I will send the document to your mail id.

bye..

Ramaa

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 4

If you have enterprise edition, it's included. There's a wizard and menu item.

If you don't, it's simple. Backup logs, copy them to the destination server, restore them with NORECOVERY.

If you tell us what's not working, clearly explain it, we can help.

Clive Strong SSChampion Points: 11222 More actions · Answer 5

Agree with Steve, use the wizard if you have enterprise edition.

We had Enterprise edition in a previous company but they still decided on a manual process using VBScript to pull/push log files from a control box. It was messy (not my design - just dumped on me before a guy left the company) but it worked...

htt SSCertifiable Points: 5242 More actions · Answer 6

I used an article at sql-server-performance.com to do manual log shipping b/w 2 SQL Std 2000 server. Worked perfectly. Search for log shipping when you go to this site.

Nalini Devarakonda SSChasing Mays Points: 636 More actions · Answer 7

hi Gouthami Putra Sathakarni,

Can you please send the document regarding replication to me.

My id is nalini.devarakonda@gmail.com

gershon adams SSC Journeyman Points: 96 More actions · Answer 8

You may want to consider third party packages that manage log shipping. Check out sonasoft and http://nadsolutions.com/default.asp

shashi_1409 SSCommitted Points: 1599 More actions · Answer 9

Hi lokanathan, could you please email the LogShipping document to shashi_1409@yahoo.co.in, I am also planning to implement logshipping in 2000 environment.

george sibbald SSC Guru Points: 104210 More actions · Answer 10

If you do only have standard edition of SQL 2000 google for 'Installing Log Shipping for SQL 7.0' by Natasha Huggins. Works also on SQL2000.

Its from the BORK (Back Office Resource Kit), has full functionality, is simple to set up and monitor, and works a dream.

I've used it for years without problem and as I have migrated to SQL 2005 and the logshipping supplied with that I kind of miss the old girl.

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

T.LOGANATHAN SSC Veteran Points: 298 More actions · Answer 11

Hi,

I will be send after find out the document.....

T.Loganathan

thang_ngo_2002 SSCrazy Points: 2187 More actions · Answer 12

This topic may can help you

http://www.sqlservercentral.com/Forums/Topic737294-24-1.aspx

Best regards

SAT_SQL Default port Points: 1465 More actions · Answer 13

HI Loganath

can u plez send to me the word document and the below is my mail id katta.satheesh@gmail.com

regards

sat_sql

MothInTheMachine Hall of Fame Points: 3242 More actions · Answer 14

Is it possible to post that document somwhere on this site?

Even as a mother protects with her life
Her child, her only child,
So with a boundless heart
Should one cherish all living beings;