RE: Can you do Log shipping on SQL SERVER 2000 Standard?

RE: Can you do Log shipping on SQL SERVER 2000 Standard?

 

  

No free tools I can think of, but it is fairly easy to script "roll your
own" log backups, then use batch files to copy, and job engine to apply
them. Your biggest issue is getting the old files deleted.




-- chip

















-----Original Message-----
From: Lancaster Steven D.
[mailto:mssqldba-ezmlmshield-x57025990.[Email address protected]
Sent: Thursday, July 28, 2005 10:53 AM
To: LazyDBA Discussion
Subject: RE: Can you do Log shipping on SQL SERVER 2000 Standard?

Is there a tool I can use to do this. Preferably free.


Turner, Padget, Graham and Laney P.A.
Steven Lancaster
Database Administrator
Phone - (803) 227-4368
Fax - (803) 400-1487
http://www.TurnerPadget.com/

-----Original Message-----
From: wchinng
[mailto:mssqldba-ezmlmshield-x11881116.[Email address protected]
Sent: Thursday, July 28, 2005 12:52 PM
To: LazyDBA Discussion
Subject: Re: Can you do Log shipping on SQL SERVER 2000 Standard?

No. The log shipping feature is only available in the Enterprise Edition of
SQL Server 2000.

Wan





"Lancaster Steven D. "
<mssqldba-ezmlmshield-x14611521.[Email address protected] on 07/28/2005
11:46:02 AM

To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: Can you do Log shipping on SQL SERVER 2000 Standard?

Turner, Padget, Graham and Laney P.A.
Steven Lancaster
Database Administrator
Phone - (803) 227-4368
Fax - (803) 400-1487
http://www.TurnerPadget.com/

CONFIDENTIAL & PRIVILEGED
Unless otherwise indicated or obvious from the nature of the above
communication, the information contained herein may be an attorney-client
privileged and confidential information/work product.
The communication is intended for the use of the individual or entity named
above. If the reader of this transmission is not the intended recipient, you
are hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error or are not sure whether it
is privileged, please immediately notify us by return e-mail and destroy any
copies, electronic, paper or otherwise, which you may have of this
communication.

'*,'".


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html








---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page