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 on SQL Server 2000 Standard Edition Expand / Collapse
Author
Message
Posted Wednesday, October 2, 2013 11:13 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 7:39 AM
Points: 66, Visits: 186
Hi All,

Thanks for looking into my question.

Do you know if it is possible to setup log shipping in SQL Server 2000 Standard edition?

If yes, is there any link or documentation on setup guidelines..

Thanks!
Siva.
Post #1500856
Posted Wednesday, October 2, 2013 10:10 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:48 PM
Points: 2,925, Visits: 2,526
Log shipping was not a feature available with SQL 2000 Standard Edition.

If you need to do this sort of this using SQL 2000 Standard Edition, you could write you own. Log shipping is a set of process that backup the transaction log, copy to the standby server, restore the log and monitoring of the processes involved. You may be able to find scripts that help create this sort of thing for you if you - there are a number of articles about this on SQL Server Central.



Post #1500977
Posted Saturday, October 5, 2013 8:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 7:39 AM
Points: 66, Visits: 186
Hi,

Thanks for your reply. Yeah. I am writing my own script to have logshipping on the standard edition.

Thanks!
Siva.

Post #1501837
Posted Thursday, October 10, 2013 4:20 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:48 PM
Points: 2,925, Visits: 2,526
I am pretty sure that someone has written scripts for this already - I think that you might find these if you search for them (they might even be in the script library here at SQL Server Central


Post #1503451
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse