Log shipping SQL 2000

Expand Post »

Hello,
I am trying to setup log shipping for SQL 2000 database. I don't see option to "specify the transaction log share". According to MS Log Shipping instruction, "specify the transaction log share" screen shows up if I have specified that the plan will install log shipping. Where do I specify that plan will use log shipping?

Thanks,

imohammed

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Nov 2008

Permalink

Nov 20th, 2008

Re: Log shipping SQL 2000

Click to Expand / Collapse Quote originally posted by imohammed ...

Hello,
I am trying to setup log shipping for SQL 2000 database. I don't see option to "specify the transaction log share". According to MS Log Shipping instruction, "specify the transaction log share" screen shows up if I have specified that the plan will install log shipping. Where do I specify that plan will use log shipping?

Thanks,

I guess I have SQL 2000 standard that's why I am not getting option for log shipping share. I found this log_shipping.zip file that has stored procedures and instructions on how to setup log shipping using t-sql. File is attached.

Attached Files

Log_shipping.zip (19.1 KB, 50 views)

Last edited by imohammed; Nov 20th, 2008 at 1:04 pm.

imohammed

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Nov 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: [B]How will I connect MS SQL to java?[/B]

Next Thread in MS SQL Forum Timeline: SQL database backup

DaniWeb Message

Cancel Changes

User Name
Password