Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Log Shipping

Status
Not open for further replies.
qsac

qsac

Programmer
Jan 22, 2002
242
0
0
US
This seems to be an answer i can not find anywhere.

I am setting up log shipping on the SQL 2000 server. The primary server is Enterprise addition. I am having a second server built.

Does the warm stand by also need 2000 Enterprise addition?

Thanks,
Q
 
Sort by date Sort by votes
Yes. All server participating in Log shipping need to have SQL Server 2000 Enterprise Editions.
 
Upvote 0 Downvote
Yes, if you are going to use the Microsoft Log shipping then they both need to be Enterprise Edition.

However if you write your own log shipping jobs then no, they don't need to both be Enterprise Edition. See my FAQ faq962-5754 for more info on writting your own log shipping.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

[noevil]
(My very old site)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GCL2007
  • Locked
  • Question
Simple Recovery model - Huge Trans Log
Replies
0
Views
80
GCL2007
GCL2007
JScannell
  • Locked
  • Question
SQL login on Classic ASP localhost site
Replies
0
Views
67
JScannell
JScannell
RRinTetons
  • Locked
  • Question
SQL Server 2008 R2 login auditing
Replies
0
Views
73
RRinTetons
RRinTetons
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
103
fredericofonseca
fredericofonseca
simian336
  • Locked
  • Question
Logins Per Second
Replies
0
Views
30
simian336
simian336

Part and Inventory Search

Sponsor

Back
Top