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

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

 

  

For the Standard Edition use the Simple Log Shipper tool, which you can find in the Microsoft SQL Server 2000 Resource Kit.
Gus

Gustavo Ibarra
FULL Solutions S.A.
Corrientes 861-Piso 5°
S2000CTH - Rosario - Argentina
+54 (341) 4264844
www.fullsolutions.com
[Email address protected]

-----Original Message-----
From: Lancaster Steven D. [mailto:mssqldba-ezmlmshield-x19070593.[Email address protected]
Sent: Jueves, 28 de Julio de 2005 14:48
To: LazyDBA Discussion
Subject: RE: Can you do Log shipping on SQL SERVER 2000 Standard?

Has anyone done this and how did you handle it?


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: Chip Smith
[mailto:mssqldba-ezmlmshield-x64508235.[Email address protected]
Sent: Thursday, July 28, 2005 1:11 PM
To: LazyDBA Discussion
Subject: 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



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